How to select one record of each from a column

  • Thread starter Thread starter Cesar Urquidi
  • Start date Start date
C

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
 
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
Click to expand...


Try this formula in cell D2:

=SMALL(A$2:A$15,1)

and this formula in cell D3:

=MIN(IF((A$2:A$15)>D2,A$2:A$15))

Copy cell D3 down as far as needed

A$15 should be changed to fit the size of your data in column A.

Hope this helps / Lars-Åke
 
Back
Top