| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling non-zero data from table
I have a large table with around 30 columns and about a hundred rows. This
table is used to break down the ingredients (columns) to make items (rows). I'd like to choose one of the items from a drop-down box, and have the function pull all the non-zero entries for that item from the table. *********** sugar wheat gum coloring flour Pop Tart 20g 5g Bread 1g 200g 200g Gummy Bear 100g 15g 5g *********** I hope that formats okay... So, the result if I chose "bread" would be a vertical list... Bread Sugar - 1g wheat - 200g flour - 200g The function would ignore all the blank cell's, and return only the ones with data. How would I get started here? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pulling non-zero data from table
On a separte tab, create a pivot table
"Akkori" wrote: I have a large table with around 30 columns and about a hundred rows. This table is used to break down the ingredients (columns) to make items (rows). I'd like to choose one of the items from a drop-down box, and have the function pull all the non-zero entries for that item from the table. *********** sugar wheat gum coloring flour Pop Tart 20g 5g Bread 1g 200g 200g Gummy Bear 100g 15g 5g *********** I hope that formats okay... So, the result if I chose "bread" would be a vertical list... Bread Sugar - 1g wheat - 200g flour - 200g The function would ignore all the blank cell's, and return only the ones with data. How would I get started here? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table pulling wrong value | Excel Discussion (Misc queries) | |||
| need some help pulling columns from one table and putting into ano | Excel Discussion (Misc queries) | |||
| Pulling table into new worksheet | Excel Discussion (Misc queries) | |||
| NEED HELP WITH PULLING IN ONLY NECESSARY DATA FROM A TABLE | Charts and Charting in Excel | |||
| Pulling from a table to make a timeline | Excel Worksheet Functions | |||
Linear Mode
