schappelljr
Board Regular
- Joined
- Feb 2, 2009
- Messages
- 55
I’ve been stuck on this problem for a while now. I have a large spreadsheet that I am trying to find when and where the 5th occurrence happens. I would like to use a helper column to display the values if not a list of the location and time would work. Below is an example.
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
unique ID | Date | Location | 5th location | 5th Date |
Steve2580 | 1/2/19 | Store 1 | ||
Steve2580 | 1/5/19 | Store 3 | ||
Amanda1665 | 1/9/19 | Store 2 | ||
Nikki5566 | 1/15/19 | Store 6 | ||
Steve2580 | 1/18/19 | Store 7 | ||
Courtney4444 | 1/20/19 | Store 2 | ||
Steve2580 | 1/22/19 | Store 4 | ||
Kevin5532 | 1/23/19 | Store 3 | ||
Steve2580 | 1/26/19 | Store 7 | Store 7 | 1/26/19 |
Frank6677 | 1/27/19 | Store 2 | ||
Steve2580 | 2/1/19 | Store 1 | ||
Steve2580 | 2/15/19 | Store 1 | ||
Xavier | 2/17/19 | Store 20 | ||
<tbody>
</tbody>