Thread: Excel How To: Reverse Ingredient List
View Single Post
Old 12-16-2015, 03:26 PM   #1
SzczerbiakManiac
"ZER-bee-ak"
 
SzczerbiakManiac's Avatar
 
Join Date: Jan 2005
Posts: 4,409
SzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of cool
Question 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?
__________________
SzczerbiakManiac is offline   Submit to Quotes Reply With Quote