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.

Lookup and Return Multiple Values
 

I have about 20000 cells

Eh, I don't like that!

See this as a last resort:

http://tinyurl.com/2vng7t

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.

Lookup and Return Multiple Values
 

Thank you for the help. The solution you gave provided the results I needed.
The key part was to sort before using the non-array formula.
Thanks again for the help.

R

"T. Valko" wrote:

I have about 20000 cells

Eh, I don't like that!

See this as a last resort:

http://tinyurl.com/2vng7t

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.

Lookup and Return Multiple Values
 

You're welcome. Thanks for the feedback!

Biff

"billinr" wrote in message
...
Thank you for the help. The solution you gave provided the results I
needed.
The key part was to sort before using the non-array formula.
Thanks again for the help.

R

"T. Valko" wrote:

I have about 20000 cells

Eh, I don't like that!

See this as a last resort:

http://tinyurl.com/2vng7t

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.