Check for dublicate data in a list, if found then substract earliest date from the latest
I'm looking for a function to calculate the average time for a RTC to travel from loading back to loading:
In the sheet i have a list of RTC's (column B) and in column A the date it was loaded.
In the column B the RTC number will be repeating, as one RTC will be reloaded on the terminal.
I created a small scheme underneath the text, what has to explain what i need. I need to subtract the date A3 - A. Not sure if the scheme is understandable.
Also the data can be repeating more than once.
A list wit data is attached. Also one example of a duplicate value is marked as red. Please note that the loading dates are different.
Re: Check for dublicate data in a list, if found then substract earliest date from the lat
Yes, this is exactly what i need. But there is a criteria i would like to add. That one and the same RTC can figure in the list many times. So it would be good that it would count always the newest date anterd in the bottom of the list withe the previous date(not the first in the for the RTC).