Hi, I have data similar to the timestamp and location fields below and need to sequence locations into visits. I can get somewhat close using the multi-row formula tool, but need to distinguish between multiple visits to the same location during the same day (rows 4-6 should be 3 not 1). Any help appreciated!
| Timestamp | Location | Desired Field |
8:56:00 | A | 1 |
| 9:05:00 | A | 1 |
| 10:30:00 | B | 2 |
| 11:41:00 | A | 3 |
| 12:13:00 | A | 3 |
| 13:56:00 | A | 3 |
| 14:20:00 | C | 4 |
