Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find earliest record based on unique identifier from a list ofdata
I have a bunch of test data. Column A is the date, Column C is the
time and Column E is the unique identifier. Because this is test data, a failed unit might be tested multiple times. What I need is a way to find the earliest test time of the unique identifier in Column E. How do I restrict the data to return me the earliest date and time for a unique unit from Column E, when the date and time are in two separate columns? Column A Column B Column C Column D Column E 12-Mar-08 XXXXXXX 15:22:25 XXXXXXXX 12345678 12-Mar-08 XXXXXXX 15:25:25 XXXXXXXX 12345679 12-Mar-08 XXXXXXX 15:28:27 XXXXXXXX 12345680 12-Mar-08 XXXXXXX 15:32:45 XXXXXXXX 12345681 12-Mar-08 XXXXXXX 16:22:25 XXXXXXXX 12345678 12-Mar-08 XXXXXXX 16:25:25 XXXXXXXX 12345679 12-Mar-08 XXXXXXX 15:28:27 XXXXXXXX 12345698 12-Mar-08 XXXXXXX 15:32:45 XXXXXXXX 12345699 In the example above there are two duplicates (12345678, and 12345679). I would only want to see the earliest of the two records based on the identifier in column E. Thanks! Lee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find unique record | Excel Discussion (Misc queries) | |||
Macro to find and record Unique values? | Excel Discussion (Misc queries) | |||
EXTRACTING UNIQUE RECORD BASED ON CONDITION | New Users to Excel | |||
EXTRACTING UNIQUE RECORD BASED ON CONDITION | Excel Worksheet Functions | |||
Unique identifier | Excel Discussion (Misc queries) |