Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup and Return Multiple Values
I have a workbook with two sheets - "Data" and "Month". In column C of Data,
I have about 20000 cells which contain point names; almost all of them are duplicated up to 30 times. In column P of the same sheet I have the measured value of each of those points. (This sheet is based on dates) What I have accomplished is to show a unique list of the point names in column C of the Month sheet. What I need to do is to show all of the measured values for each point in the proper row on the Month sheet, beginning in the G column. for example: Data C P 123 0.1 124 0.2 125 0.1 123 0.2 Month C G H I 123 0.1 0.2 etc. There is some additional filtering I will do, then I am going to have about 500 points after the unique list is built and displayed on the Month sheet. Any help is appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup and Return Multiple Values
See one reply to your other post
Biff "billinr" wrote in message ... I have a workbook with two sheets - "Data" and "Month". In column C of Data, I have about 20000 cells which contain point names; almost all of them are duplicated up to 30 times. In column P of the same sheet I have the measured value of each of those points. (This sheet is based on dates) What I have accomplished is to show a unique list of the point names in column C of the Month sheet. What I need to do is to show all of the measured values for each point in the proper row on the Month sheet, beginning in the G column. for example: Data C P 123 0.1 124 0.2 125 0.1 123 0.2 Month C G H I 123 0.1 0.2 etc. There is some additional filtering I will do, then I am going to have about 500 points after the unique list is built and displayed on the Month sheet. Any help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup and Return Multiple Values | Excel Worksheet Functions | |||
lookup and return multiple values | Excel Discussion (Misc queries) | |||
lookup and return multiple values | Excel Worksheet Functions | |||
Lookup one value and return multiple corresponding values | Excel Discussion (Misc queries) | |||
Lookup and return multiple Values | Excel Worksheet Functions |