Hi,
I need to show how many suppliers there are of particular ingredients. Some ingredients may have one supplier or there may be two suppliers of a particular ingredient. See sample table below. What's the easiest way to do this? If I do a VLOOKUP it will only pull up one supplier for tomatoes (see table below).
I have a feeling I should be using Pivot...
I need to show how many suppliers there are of particular ingredients. Some ingredients may have one supplier or there may be two suppliers of a particular ingredient. See sample table below. What's the easiest way to do this? If I do a VLOOKUP it will only pull up one supplier for tomatoes (see table below).
I have a feeling I should be using Pivot...
Ingredient | Supplier |
Tomatoes | Johnson & sons |
Tomatoes | MD supplies |
Oranges | MD supplies |
Apples | Tom's Fresh fruit & Veg |