return values from an array based on more than one criteria

[frustratedjohn]

I have an array that has components as the top row and products as the first
column. I want to be able to create a list for n aay given product of the
components contained in it, there could be several, i.e. say the product is
flange assembly, it contains a flange bolts, nuts and washers, the row of
components has not only these components but sockets, elbows and tees. Any
ideas on how this can be done? Any help would be greatly appreciated!

 

[Bernie Deitrick]

John,

What is present in the intersection of the row and column to indicate that
the component is used in the product?

And shortened example with what you eventually want would help....

HTH,
Bernie
MS Excel MVP

 

[frustratedjohn]

Bernie:

The values in the array are the quantity of that item found in the assembly
i.e.

Product Flange Assembly
Bolts 4
Nuts 4
Washers 8

Hope this helps

frustrated John

 

[Bernie Deitrick]

John,

I think the easiest thing would be for you to select your entire table, and
then use Data / Filter Autofilter . Then from the dropdown at the top of
any column, select "non blank" and you will get a list of just those filled
in cells. Select the cells, copy, and paste elsewhere, and the cells hidden
by the filter should not be copied.

HTH,
Bernie
MS Excel MVP