I have a list of serial numbers that have different scan dates:
Serial # Started Ended Count
L50099 28-02-14 11:50 28-02-14 15:20 1
L50099 25-11-15 15:55 25-11-15 19:25 2
L50098 03-03-16 11:30 03-03-16 15:00 1
L50099 01-07-16 13:37 01-07-16 17:07 3
How do I return the cell of the previously Ended date?
For example, how do I return 03/03/16 3:00 PM (row C, Ended column) into row D in the Prev column? And the rest for all the others?
My actual data will have a heap of other serial numbers and dates in between, this is just an example.
I'm trying index/match and vlookup but it's fixated onto the same column, not one previous to it.
EDIT: Can I use INDEX MATCH MATCH to get the date for the serial # of the count, minus 1, which is the date of the previous count?
The formula for the Count column is =COUNTIF(A$2:A2,A2)