RonFos3394
New Member
- Joined
- Jun 19, 2023
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi
Hoping someone can help, been racking my brains for a while on this one.
I've got a table of data from A5:AD15000. In column B:B is dates/times. In Column S:S is serial numbers and will have duplicate values.
*Note there may be more than 1 duplicate of the same value however I only want it to look for 2nd duplicate then if it finds the same serial again to treat it as another entry and look for a 2nd duplicate. (hope this makes sense).
The data table is sorted by date/time.
I'm wanting to find a formula that if a duplicate value is found within S:S to return the date/time located in the column B:B of the duplicate value. So I can find out the time difference between the two serial numbers.
Alternatively, if I can find the duplicates and have the formula work out if the date/time in B:B is within 48 hours to return "TRUE" or "FALSE".
Any help would be awesome!
Cheers
Hoping someone can help, been racking my brains for a while on this one.
I've got a table of data from A5:AD15000. In column B:B is dates/times. In Column S:S is serial numbers and will have duplicate values.
*Note there may be more than 1 duplicate of the same value however I only want it to look for 2nd duplicate then if it finds the same serial again to treat it as another entry and look for a 2nd duplicate. (hope this makes sense).
The data table is sorted by date/time.
I'm wanting to find a formula that if a duplicate value is found within S:S to return the date/time located in the column B:B of the duplicate value. So I can find out the time difference between the two serial numbers.
Alternatively, if I can find the duplicates and have the formula work out if the date/time in B:B is within 48 hours to return "TRUE" or "FALSE".
Any help would be awesome!
Cheers