Trying to record time between changes in specific contact names

atewari1

@KPH Progress is the motto!

The formula works thank you! I see now that the difference being calculated is always based on the first instance of the unique identifier. So differences in response time are being made from the first instance of a name in any given row ID rather than the immediately previous one

KPH

Hi @atewari1

Did you complete Part 2 of the message on April 4th? The difference formula needs to use the values in the COUNTIF column you added. You will be comparing the current row with the row that has the same details but the COUNTIF is the same minus 1.

atewari1

@KPH Progress is the motto!

With this formula I am getting the correct difference between a pair of IDs. The issue I have now is if there are several entries associated to an ID, the difference will only calculate from the first instance of the ID and not the previous one.

KPH

Can you share the IDs that you now have - each should be unique, based on the row ID.