Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to select one record of each from a column | Excel Discussion (Misc queries) | |||
Finding the next record in a column | Excel Discussion (Misc queries) | |||
How do I automatically select a Excel record randomly? | Excel Worksheet Functions | |||
Select last record for each account | Excel Discussion (Misc queries) | |||
How do I select the correct record? | Excel Discussion (Misc queries) |