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