Pulling non-zero data from table

A

Akkori

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!
 
A

AndyLV

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!
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count of Non-Zero pivot table entries 1
Hide zero totals in pivot table report 3
Pivot table data layout - columns to rows 1
text parsing/table creation from single column data 1
Updating cell data from a table with an ID 1
how do I create a drop-down list which is ordered from another table? 4
Can I transpose data from rows to cols with a formula not pivot ta 1
Possible to use pivot table on non-mumeric fact data withoutcalculating? 3

Top