| 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! |
| 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 | |||
Threaded Mode
