Excel How To: Reverse Ingredient List

SzczerbiakManiac · 12-20-2015, 04:06 PM

Quote:

Originally Posted by scaeagles

I could write you a SQL query but that's not going to help you much.

How much would you charge?

Moonliner · 12-20-2015, 07:49 PM

How are they listed in the table:

A1 French Toast
A2 Eggs
A3 Cinnamon
A4 Butter
A5 Pancakes
A6 Eggs
A7 Flour
.
.
.

How can you tell an ingredient cell from an item cell?

SzczerbiakManiac · 12-21-2015, 09:09 AM

Quote:

Originally Posted by Moonliner

How are they listed in the table:

Like this:
A1 French Toast
A2 Eggs
A3 Cinnamon
A4 Butter

A6 Pancakes
A7 Eggs
A8 Flour

It's essentially a plain list, but each item is listed in its own cell. Each recipe/ingredient list is separated by an empty row. I can fiddle with the layout of that would help. E.g., either of these would be easy to accomplish with a quick bunch of cut & pastes:
A1 French Toast
A2 Eggs
A3 Cinnamon
A4 Butter

B1 Pancakes
B2 Eggs
B3 Flour
_____________________________

A1 French Toast
B2 Eggs
B3 Cinnamon
B4 Butter

A6 Pancakes
B7 Eggs
B8 Flour

12-20-2015, 07:49 PM	#2
Moonliner 8/30/14 - Disneyland -10k or Bust. Join Date: Jan 2005 Posts: 9,022	How are they listed in the table: A1 French Toast A2 Eggs A3 Cinnamon A4 Butter A5 Pancakes A6 Eggs A7 Flour . . . How can you tell an ingredient cell from an item cell? __________________ - Taking it one step at a time.
	Submit to Quotes