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?