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