I have a large record.
I have serial numbers, which have many entries on the worksheet.
I need values, for each serial number, that are associated with both the latest and earliest date.
So basically I want to look for the Serial number, check which entry for that serial number has the latest date and time, and then return that value.
Then, in another column, look for the serial number, check which entry is the earliest date and time, and return the value.
Example
For serial code 123, I'd want to return the latest date's (and time's) value in one formula, which would be 1.34
Also the Earliest which would be 12.34
for 456 it would be 5.67 for the latest and the other formula would return 4.566
for 789 both would return 1.34.
Thanks. Any help is appreciated!
Bookmarks