Renaissance
Board Regular
- Joined
- Jun 20, 2013
- Messages
- 58
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". |
<tbody>
</tbody>
Name | Type | Trait | Number | Cost | Time |
John | B | Y | 125 | $550 | Sep-13 |
John | A | Y | 200 | $300 | Oct-13 |
John | B | Y | 300 | $600 | Nov-13 |
John | B | Y | 125 | $600 | Dec-13 |
<tbody>
</tbody>
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.