Days difference between two adjacent duplicate PIN numbers

User Talk Formulas
1

Hi have multiple visit of same PIN number and i want to calculate number of days between the visits and add it to next coulmn called “days difference”.

Is it possible that a formula checks for Duplicate PIN number in next row and if found can output “days difference” between visit?

I have almost no knowledge about formulas. Any help will be appreciated.

Here is my screenshot of columns

16788093238451627700851196412406
167880932384516277008511964124061920×2560 681 KB

2

To be able to help you, I need further information.

What is the specific use case you want to show here, and which SeaTable version do you use?