Max,
I used the spreadsheet you gave me and copied the formulas exactly into my
spreadsheet and for some reason in the spreadsheet I'm using, it doesn't give
me the same LC data as in your example - it gives me row numbers. Can this
have something to do with how my cell is formatted. It's a form I've set up
in excel.
Thanks,
Jana

"Max" wrote:

Try this sample file which contains the implemented construct:
http://cjoint.com/?kBqvXyjRnp
(Things should be clearer, I hope)

The formula you gave me for column E
puts the row #, not the value in the cell.

Yes, nothing wrong there <g. Col E is a helper criteria col. The row
numbers returned are arbitrary values which will be read by the formulas in
sheet: B

Also, the formula you gave me to put in A1 is looking at row E in
worksheet
B, not worksheet A where the data is. How do I change that to lookin
column
E, worksheet A?

Nothing wrong here, too. The desired unique values are returned correctly
from col A in Sheet: A by the INDEX(A!A:A ... part of the formula which
points to col A in sheet: A.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"JANA" wrote in message
...
Thanks Max, still a problem though. The formula you gave me for column E
puts the row #, not the value in the cell.

Also, the formula you gave me to put in A1 is looking at row E in
worksheet
B, not worksheet A where the data is. How do I change that to lookin
column
E, worksheet A?