Originally Posted by

**6StringJazzer**
Here is an example of how this could be done with formulas. If this is not what you had in mind then please attach your own file with realistic sample data.

Column D is the sequence of all possible ID numbers.

Column E looks up the first time for the corresponding ID number. If that ID number is not found, the result is blank.

Column F looks up the second time for the corresponding ID number. It does this by setting the lookup area to start in the next row after the first time for that number.

In the formula in column F change 99 to the maximum number of rows of data you could have.

## Bookmarks