Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
return values from an array based on more than one criteria
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
return values from an array based on more than one criteria
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" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
return values from an array based on more than one criteria
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" wrote: 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" wrote in message ... 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! . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
return values from an array based on more than one criteria
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 "frustratedjohn" wrote in message ... 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" wrote: 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" wrote in message ... 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! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding the Max, Min values based on certain criteria for an array | Excel Discussion (Misc queries) | |||
Return an array based on a lookup | Excel Worksheet Functions | |||
return values from an array based on matching text value | Excel Worksheet Functions | |||
Use array to return array of values | Excel Worksheet Functions | |||
match multiple criteria & return value from array | Excel Worksheet Functions |