I'm stumped. Been trying this all morning.
I have an excel file with two sheets:
A. Master List + Output -- contains the base list of value that I want to check presence for against in all other columns in the "Daily Orders" sheet.
B. Daily Orders -- contains lists of each day's purchased items. Will grow to the right.
I'm trying to check for each item in the "master-list" to see if it appears in each column in the "daily orders" sheet. If it appears in each column, then print it in the "output" column, preferably to match the master-list order from top down.
Imagine I was trying to build a list over time that could output what food items from a master list are ordered on every date.
Is there a way to do this? Many thanks for any suggestions.
Master List and Output Sheet
<tbody>
</tbody>
Daily Orders Sheet
<tbody>
</tbody>
I have an excel file with two sheets:
A. Master List + Output -- contains the base list of value that I want to check presence for against in all other columns in the "Daily Orders" sheet.
B. Daily Orders -- contains lists of each day's purchased items. Will grow to the right.
I'm trying to check for each item in the "master-list" to see if it appears in each column in the "daily orders" sheet. If it appears in each column, then print it in the "output" column, preferably to match the master-list order from top down.
Imagine I was trying to build a list over time that could output what food items from a master list are ordered on every date.
Is there a way to do this? Many thanks for any suggestions.
Master List and Output Sheet
MASTER-LIST | VALUE-APPEARS-CONSISTENTLY-IN-EACH-DAILY-COLUMN-OUTPUT | ||||
apples | apples | ||||
kiwi | sausage | ||||
sausage | cereal | ||||
cereal | |||||
potatoes |
<tbody>
</tbody>
Daily Orders Sheet
AUG-1 | AUG-12 | AUG-15 | AUG-19 | + | |
apples | apples | chicken | banana | ||
banana | sausage | apples | sausage | ||
broth | pasta | sausage | lettuce | ||
celery | cereal | potatoes | apples | ||
sausage | squash | cereal | kiwi | ||
cereal | potatoes | cereal |
<tbody>
</tbody>