How to select one record of each from a column
 

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

How to select one record of each from a column
 

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

How to select one record of each from a column
 

On Fri, 20 Nov 2009 09:16:01 -0800, 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


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