Excel How To: Reverse Ingredient List

SzczerbiakManiac · 12-16-2015, 03:26 PM

The actual lists are more complicated, but for simplicity, let's say I have this list of recipes in Excel that looks like this:
French Toast

Eggs
Bread
Butter

Pancakes

Eggs
Flour
Sugar

Hollandaise Sauce

Eggs
Butter
Lemon

What I need is a list of ingredients with what recipes they're used in. E.g., Eggs are used in French Toast, Pancakes, and Hollandaise. Butter is used in French Toast and Hollandaise. Flour is only used in Pancakes.

Is there a relatively easy way to create that?

12-16-2015, 03:26 PM	#1
SzczerbiakManiac "ZER-bee-ak" Join Date: Jan 2005 Posts: 4,409	Excel How To: Reverse Ingredient List The actual lists are more complicated, but for simplicity, let's say I have this list of recipes in Excel that looks like this: French Toast Eggs Bread Butter Pancakes Eggs Flour Sugar Hollandaise Sauce Eggs Butter Lemon What I need is a list of ingredients with what recipes they're used in. E.g., Eggs are used in French Toast, Pancakes, and Hollandaise. Butter is used in French Toast and Hollandaise. Flour is only used in Pancakes. Is there a relatively easy way to create that? __________________
	Submit to Quotes