Auto Numbering Sorting with Previous Row

[biha]

@ThinhDinh ,

I just found this thread. I managed to do what i need, based on your idea. Hehehehheheehe, thank you.

What did you eat everyday eh? because so brilliant.

Find Value from Previous Row

So I assume you store each place’s address/coordinates? What you can do is this: Create an index for each row, as described below Please note that the index should be related to each “trip” only, since you want to index each row based only on their respective list. You should have a “Trip ID” that is unique to each trip. Create a Math column, name it “Previous Index”, take the index from the 1st step, minus 1. Create a Template column, name it “Previous Index Temp”, the template should j…