Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Im trying to simplify shopping lists in my home. I have a basic list that we
can complete weekly. how can i generate from this a list that will only include items and stores that have to be shopped at? I am primarily looking for a list that the column headers will be source and the row headers just the items that have a value in the quantity column with the quantity showing under the proper column. So that a list that starts like this: Item Source Quantity Alaskan Salmon Trader Joes Almond Milk Whole Foods 1 Apple Cider Smart & Final 3 Apple Juice Smart & Final 7 Apples Ralphs will generate a list that looks like this: Whole Foods Smart & Final Almond Milk 1 Apple Cider 3 Apple Juice 7 Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to generate a list from a table | Excel Discussion (Misc queries) | |||
Generate list from column | Excel Worksheet Functions | |||
How can I generate a list of the worksheets by name | Excel Discussion (Misc queries) | |||
generate a selective list | Excel Discussion (Misc queries) | |||
generate a menu list | Excel Discussion (Misc queries) |