Index rows

[CCares17]

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

[Chantelb · Accepted solution]

Hi  @CCares17 ,

You're right, you could use a multi-row formula tool: 

IF ISNULL([Row-1:Desired Field]) THEN 1
ELSEIF [Row-1:Location] = [Location] THEN [Row-1:Desired Field]
ELSE [Row-1:Desired Field] + 1
ENDIF

Let me know if this helps

[Qiu]

@CCares17 
What is the logic for row#1 and row#2?

[CCares17]

Yes, this is exactly what I needed, thank you!