Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning multiple values
I have an array of raw data that spans 15 columns and 4000 rows. In column 1
there is a part number and in colum 12 there is a customer name. These part numbers overlap to customers fairly often (up to 20 customers for a part number). How would I, on a separate sheet, return all the customers who use this part number? This is what I am looking to do: Part Number Customer 1 A 2 A 1 B 3 B 4 B 5 B 1 C 2 C 3 C 1 D 4 E On a separate sheet how do I return the following, without having to sort the raw data: P/N Customer(s) 1 A, B, C, D 2 A, C 3 B 4 B, E 5 B, C Thanks for the help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning Multiple values | Excel Worksheet Functions | |||
Looking up multiple values and returning one corresponding value | Excel Worksheet Functions | |||
Returning multiple values from a list | Excel Discussion (Misc queries) | |||
vlookup returning multiple values | Excel Worksheet Functions | |||
Returning Multiple Values Based on One Value | Excel Worksheet Functions |