Spreadsheet: 825919d1681643876-identifying-duplicate-records-with-formula-for-conditional-formatting-data-edit
Sheet: Sheet 1

DATE | TIME | PHONE NAME | TO / FROM | NUMBER NAME | NUMBER | ORIGINATION | DESTINATION | Match Above | Duplicate
2023-06-26 00:00:00 | 13:11:00 | JMN |  |  | [PHONE] | Libertyvil, IL | Incoming, CL |  |  |  |  |  |  | Adjacent rows manually highlighted in gray are duplicates of each other as shown by matching [NAME] and Times and the exact reversal of the "PHONE NAME" and the "NUMBER NAME".  Also they are companion calls as there is a From and To.
2023-06-26 00:00:00 | 13:11:00 | MEN |  |  | [PHONE] | [NAME], IL | Elgin,IL
2023-06-26 00:00:00 | 13:56:00 | JMN |  |  | [PHONE] | [NAME], IL | LA Grange, IL
2023-06-26 00:00:00 | 18:40:00 | MEN |  |  | [PHONE] | Buffalo Gr, IL | Roselle, IL
2023-06-26 00:00:00 | 18:41:00 | MEN |  |  | [PHONE] | Buffalo Gr, IL | Incoming, CL
2023-06-26 00:00:00 | 18:41:00 | NLN |  |  | [PHONE] | [NAME], IL | Chicago, IL
2023-06-27 00:00:00 | 10:42:00 | KAN |  |  | [PHONE] | Chicago, IL | Elgin, IL
2023-06-27 00:00:00 | 17:34:00 | JMN |  |  | [PHONE] | Las Vegas, NV | LA Grange, IL
2023-06-27 00:00:00 | 18:18:00 | MEN |  |  | [PHONE] | Palatine, IL | Roselle, IL
2023-06-27 00:00:00 | 18:18:00 | NLN |  |  | [PHONE] | [NAME], IL | Incoming, CL
2023-06-29 00:00:00 | 15:38:00 | JMN |  |  | [PHONE] | Las Vegas, NV | LA Grange, IL
2023-06-29 00:00:00 | 18:47:00 | JMN |  |  | [PHONE] | Las Vegas, NV | Northbrook, IL |  |  |  |  |  |  | Adjacent rows manually highlighted in yellow are duplicates by Dates and Times but are not an exact duplicate in some cases by virtue of the 'PHONE NAME" and "NUMBER NAME" and there is no corresponding "From" call.  These would not be true duplicates
2023-06-29 00:00:00 | 18:47:00 | JMN |  |  | [PHONE] | Las Vegas, NV | LA Grange, IL
2023-06-29 00:00:00 | 18:47:00 | KAN |  |  | [PHONE] | Las Vegas, NV | Elgin, IL
2023-06-29 00:00:00 | 18:48:00 | JMN |  |  | [PHONE] | Las Vegas, NV | Incoming, CL
2023-06-30 00:00:00 | 10:34:00 | KAN |  |  | [PHONE] | Las Vegas, NV | Elgin, IL
2023-07-01 00:00:00 | 17:56:00 | MEN |  |  | [PHONE] | Lake Fores, IL | Incoming, CL
2023-07-01 00:00:00 | 21:48:00 | JMN |  |  | [PHONE] | Las Vegas, NV | LA Grange, IL
2023-07-01 00:00:00 | 21:48:00 | JMN |  |  | [PHONE] | Las Vegas, NV | Northbrook, IL
2023-07-03 00:00:00 | 18:35:00 | KAN |  |  | [PHONE] | Darien, IL | Elgin, IL
2023-07-03 00:00:00 | 19:45:00 | JMN |  |  | [PHONE] | Las Vegas, NV | LA Grange, IL
2023-07-05 00:00:00 | 12:09:00 | MEN |  |  | [PHONE] | Lake Zuric, IL | Incoming, CL |  |  |  |  |  |  | GOAL:  Remove the "From" row where the "DATE" and TIME" match the corresponding ("duplicate") row and the "PHONE NAME" and "NUMBER NAME" are the reverse of each other.
2023-07-05 00:00:00 | 12:09:00 | KAN |  |  | [PHONE] | [NAME], IL | Chicago, IL
2023-07-05 00:00:00 | 12:52:00 | JMN |  |  | [PHONE] | Las Vegas, NV | Incoming, CL
2023-07-05 00:00:00 | 14:29:00 | KAN |  |  | [PHONE] | [NAME], IL | Incoming, CL
2023-07-06 00:00:00 | 18:19:00 | MEN |  |  | [PHONE] | Buffalo Gr, IL | Incoming, CL
2023-07-06 00:00:00 | 18:19:00 | NLN |  |  | [PHONE] | [NAME], IL | Chicago, IL |  |  |  |  |  |  | In this sampling, there are only 5 true duplicates to be highlighted with conditional formatting.  They are the records with a manually applied red border.
2023-07-06 00:00:00 | 18:55:00 | JMN |  |  | [PHONE] | Las Vegas, NV | LA Grange, IL
2023-07-06 00:00:00 | 19:05:00 | JMN |  |  | [PHONE] | Las Vegas, NV | Incoming, CL
DATE | TIME | PHONE NAME | TO / FROM | NUMBER NAME | NUMBER | ORIGINATION | DESTINATION
2023-06-26 00:00:00 | 13:11:00 | JMN |  |  | [PHONE] | Libertyvil, IL | Incoming, CL |  |  |  |  |  |  | This is how the data should look after condiitonal formatting by formula applied.
2023-06-26 00:00:00 | 13:11:00 | MEN |  |  | [PHONE] | [NAME], IL | Elgin,IL
2023-06-26 00:00:00 | 13:56:00 | JMN |  |  | [PHONE] | [NAME], IL | LA Grange, IL
2023-06-26 00:00:00 | 18:40:00 | MEN |  |  | [PHONE] | Buffalo Gr, IL | Roselle, IL
2023-06-26 00:00:00 | 18:41:00 | MEN |  |  | [PHONE] | Buffalo Gr, IL | Incoming, CL
2023-06-26 00:00:00 | 18:41:00 | NLN |  |  | [PHONE] | [NAME], IL | Chicago, IL
2023-06-27 00:00:00 | 10:42:00 | KAN |  |  | [PHONE] | Chicago, IL | Elgin, IL
2023-06-27 00:00:00 | 17:34:00 | JMN |  |  | [PHONE] | Las Vegas, NV | LA Grange, IL
2023-06-27 00:00:00 | 18:18:00 | MEN |  |  | [PHONE] | Palatine, IL | Roselle, IL
2023-06-27 00:00:00 | 18:18:00 | NLN |  |  | [PHONE] | [NAME], IL | Incoming, CL
2023-06-29 00:00:00 | 15:38:00 | JMN |  |  | [PHONE] | Las Vegas, NV | LA Grange, IL
2023-06-29 00:00:00 | 18:47:00 | JMN |  |  | [PHONE] | Las Vegas, NV | Northbrook, IL
2023-06-29 00:00:00 | 18:47:00 | JMN |  |  | [PHONE] | Las Vegas, NV | LA Grange, IL
2023-06-29 00:00:00 | 18:47:00 | KAN |  |  | [PHONE] | Las Vegas, NV | Elgin, IL
2023-06-29 00:00:00 | 18:48:00 | JMN |  |  | [PHONE] | Las Vegas, NV | Incoming, CL
2023-06-30 00:00:00 | 10:34:00 | KAN |  |  | [PHONE] | Las Vegas, NV | Elgin, IL
2023-07-01 00:00:00 | 17:56:00 | MEN |  |  | [PHONE] | Lake Fores, IL | Incoming, CL
2023-07-01 00:00:00 | 21:48:00 | JMN |  |  | [PHONE] | Las Vegas, NV | LA Grange, IL
2023-07-01 00:00:00 | 21:48:00 | JMN |  |  | [PHONE] | Las Vegas, NV | Northbrook, IL
2023-07-03 00:00:00 | 18:35:00 | KAN |  |  | [PHONE] | Darien, IL | Elgin, IL
2023-07-03 00:00:00 | 19:45:00 | JMN |  |  | [PHONE] | Las Vegas, NV | LA Grange, IL
2023-07-05 00:00:00 | 12:09:00 | MEN |  |  | [PHONE] | Lake Zuric, IL | Incoming, CL
2023-07-05 00:00:00 | 12:09:00 | KAN |  |  | [PHONE] | [NAME], IL | Chicago, IL
2023-07-05 00:00:00 | 12:52:00 | JMN |  |  | [PHONE] | Las Vegas, NV | Incoming, CL
2023-07-05 00:00:00 | 14:29:00 | KAN |  |  | [PHONE] | [NAME], IL | Incoming, CL
2023-07-06 00:00:00 | 18:19:00 | MEN |  |  | [PHONE] | Buffalo Gr, IL | Incoming, CL
2023-07-06 00:00:00 | 18:19:00 | NLN |  |  | [PHONE] | [NAME], IL | Chicago, IL
2023-07-06 00:00:00 | 18:55:00 | JMN |  |  | [PHONE] | Las Vegas, NV | LA Grange, IL
2023-07-06 00:00:00 | 19:05:00 | JMN |  |  | [PHONE] | Las Vegas, NV | Incoming, CL