Hello I am looking to find duplicates with a three column criteria:
In this case, I want a formula to return TRUE for Channel 1, Video 1, Date 1/1/2000, because it had duplicates for the same row in these 3 different columns
In this case, I want a formula to return TRUE for Channel 1, Video 1, Date 1/1/2000, because it had duplicates for the same row in these 3 different columns
Channel | Name | Date | Result |
Channel 1 | Video 1 | 1/1/2000 | TRUE |
Channel 1 | Video 2 | 1/1/2000 | FALSE |
Channel 2 | Video 1 | 1/1/2000 | FALSE |
Channel 1 | Video 1 | 1/1/2000 | TRUE |