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
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$1:D1,0)),ROW($ A$1:$A$15))), INDEX($A$1:$A$15,MIN(IF(ISNA(MATCH($A$1:$A$15,$D$1 :D1,0)), ROW($A$1:$A$15)))),"") 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 |
All times are GMT +1. The time now is 12:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com