How to select one record of each from a column

[Cesar Urquidi]

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

 

[Jacob Skaria]

In D1 enter formula
=A1

In D2 enter the below formula and copy down as required.
Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula>}"

=IF(MIN(IF(ISNA(MATCH($A$1:$A$15,$D$11,0)),ROW($A$1:$A$15))),
INDEX($A$1:$A$15,MIN(IF(ISNA(MATCH($A$1:$A$15,$D$11,0)),
ROW($A$1:$A$15)))),"")

If this post helps click Yes