Most valuable professional
  • Hot Topics

Excel Excel many to many

How can I in Excel, resolve this question about this table: Invoice Number | Item | Product | Value 1001 | 1 | potatoes | 100 1001 | 2 | tomatoes | 150 1002 | 1 | potatoes | 100 1003 | 1 | water | 50 1004 | 1 | potatoes | 100 1004 | 2 | onions | 120 If I ask the questions: Which an how many of these invoices have no potatoes or tomatoes ? the answer should be, in this case: invoice 1003 / number = 1 How can I find it in Excel? Is there a formula for this question?

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of September 24, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel