Check your other post..You dont need to multi-post

If this post helps click Yes
---------------
Jacob Skaria


"Cesar Urquidi" wrote:

Hello,
I have a large worksheet with data.

Here are the columns (a,b & c):

Order # Employee Hrs.
1000 Mike 2
2000 Mike 1
1000 Paul 2
3000 Rose 3
8000 Mike 1
3000 Mike 2
1000 Rose 1
4000 Paul 1
7000 Jhon 3
5000 Rose 2
1000 Jhon 3
6000 Mike 1
9000 Mike 3
1000 Mike 2

Is there a formula to select only one of each record on "Order #" (column a)
and put them on
another column (column d)???

Once the formula is created, column d should look like this:

1000
2000
3000
4000
5000
6000
7000
8000
9000

Help please!!!

Thank you,
Cesar Urquidi