Returning Non Zero labels and quantities Without arrays

IDS2019

New Member
Joined
Mar 29, 2019
Messages
1
We have a database that keeps track of installed inventory and allows an auditor to record the type of inventory installed and the number that is installed. The auditor records this in a table that has all of the types of inventory populating a pull-down menu and a column to record the number installed. Then we have another sheet that contains a summary table of all of the possible types (ie the same types found in the pull-down menu) and the total number of each type recorded, or a zero is shown where none of one or more types is not installed.


What we’re looking to do is to have the non-zero results (and only the non-zero results) from the summary table populate the column headers of another sheet. (Then we record additional information like pricing etc in those columns.) Again, we want only the total numbers from the summary page for inventory types that were found to be installed, and to skip the inventory types where none are installed.

[FONT=&quot]Inventory Type

<tbody class="">

[FONT=&quot]# Installed[/FONT]
[FONT=&quot]Type 1[/FONT]
[FONT=&quot]0[/FONT]
[FONT=&quot]Type 2[/FONT]
[FONT=&quot]10[/FONT]
[FONT=&quot]Type 3[/FONT]
[FONT=&quot]5[/FONT]
[FONT=&quot]Type 4[/FONT]
[FONT=&quot]0[/FONT]
[FONT=&quot]Type 5[/FONT]
[FONT=&quot]0[/FONT]
[FONT=&quot]Type 6[/FONT]
[FONT=&quot]1[/FONT]

</tbody>





[FONT=&quot]Type 2[/FONT]
[FONT=&quot]Type 3[/FONT]
[FONT=&quot]Type 6[/FONT]
[FONT=&quot]# Installed[/FONT]
[FONT=&quot]10[/FONT]
[FONT=&quot]5[/FONT]
[FONT=&quot]4[/FONT]
[FONT=&quot]Price[/FONT]
[FONT=&quot]$x[/FONT]
[FONT=&quot]$y[/FONT]
[FONT=&quot]$z[/FONT]
[FONT=&quot]Location[/FONT]
[FONT=&quot]Location 1[/FONT]
[FONT=&quot]Location 1[/FONT]
[FONT=&quot]Location 2[/FONT]
[FONT=&quot]Etc.[/FONT]







<tbody class="">
</tbody>
[/FONT]
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,122,232
Messages
5,594,956
Members
413,954
Latest member
mrsandy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top