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