How to select one record of each from a column

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
 
J

Jacob Skaria

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

If this post helps click Yes
 
L

Lars-Åke Aspelin

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


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top