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
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