|Hey Guys, in the example below I am looking primarily at columns D (Number) and F (Time). What I hope to accomplish is to search for the duplicates (125 in this example) and count the time difference between them.|
I'm not concerned about where I need to place this information, and I'm assuming I will need at least one or two columns. My question is: How do I do this? A combination of =Countif($D$2:$D$5,$D5)>1 and something else?
I am curious how long a replacement is lasting, which would be indicated by more than a single replacement per individual "Number".
Thanks in advance for taking the time to help me out. I'm thinking there is a simple solution, but I'm not sure how to best tackle this.