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?

"Max" wrote:

One way ..

In sheet: A
-------
In an empty col to the right, say col E,
Put in E1: =IF(A1="","",IF(COUNTIF($A$1:A1,A1)1,"",ROW()))
Copy down to say, E100, to cover the max expected data in col A

In sheet: B
-------
Put in A1:
=IF(ISERROR(SMALL(A!E:E,ROWS($A$1:A1))),"",
INDEX(A!A:A,MATCH(SMALL(A!E:E,ROWS($A$1:A1)),A!E:E ,0)))

Copy down to A100
(cover the same extent as done in col E in "A")

The above will return the required results from "A",
all neatly bunched at the top
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"JANA" wrote in message
...
I have a worksheet that has multiple labor categories listed on different
lines. On another worksheet I want to pull each labor category only once
and
put them each on a different line. Please see example below. Is there a
way
to do this in excel and if so how?
Thanks,
Jana

WORKSHEET A
A
1 S1
2 T3
3 T4
4 S1
5 T3
6 S2

I want the formulas in worksheet B so they will deliver the following
data -
don't need them in any certain order, just need each to only list once on
a
different line.
WORKSHEET B
A
1 S1
2 S2
3 T3
4 T4