I have a large data file. In this table, there are 3 columns with repeating information, but I need to identify the where the data has duplicates (x 3).
I haven't been able to try anything, as I am drawing a blank as to what I could use as a conditional formatting formula.
Column A: has binary data. Example "1 & 0" Column B: has the 11 repeating descriptive data. Example "A to K" Column C: has the date
Each data is repeated multiple times in each column, but I need to identify when it is repeated for the same date (found in column C).
In the example below, I would want to identify the duplicate of
Column A: 1
Column B: C
Column C: 25-04-01
The "1" and "C" show up twice for the date "25-04-01" (YY-MM-DD) which is why I need it formatted and thus standing out of the lot.
| Column A | Column B | Column C |
|---|---|---|
| 0 | A | 25-04-01 |
| 0 | B | 25-04-01 |
| 0 | C | 25-04-01 |
| 0 | D | 25-04-01 |
| 0 | E | 25-04-01 |
| 0 | F | 25-04-01 |
| 0 | G | 25-04-01 |
| 0 | H | 25-04-01 |
| 0 | I | 25-04-01 |
| 0 | J | 25-04-01 |
| 0 | K | 25-04-01 |
| 1 | A | 25-04-01 |
| 1 | B | 25-04-01 |
| 1 | C | 25-04-01 |
| 1 | C | 25-04-01 |
| 1 | D | 25-04-01 |
| 1 | E | 25-04-01 |
| 1 | F | 25-04-01 |
| 1 | G | 25-04-01 |
| 1 | H | 25-04-01 |
| 1 | I | 25-04-01 |
| 1 | J | 25-04-01 |
| 1 | K | 25-04-01 |
| 0 | A | 25-04-02 |
| 0 | B | 25-04-02 |
| 0 | C | 25-04-02 |
| 0 | D | 25-04-02 |
| 0 | E | 25-04-02 |
| 0 | F | 25-04-02 |
| 0 | G | 25-04-02 |
| 0 | H | 25-04-02 |
| 0 | I | 25-04-02 |
| 0 | J | 25-04-02 |
| 0 | K | 25-04-02 |
| 1 | A | 25-04-02 |
| 1 | B | 25-04-02 |
| 1 | C | 25-04-02 |
| 1 | D | 25-04-02 |
| 1 | E | 25-04-02 |
| 1 | F | 25-04-02 |
| 1 | G | 25-04-02 |
| 1 | H | 25-04-02 |
| 1 | I | 25-04-02 |
| 1 | J | 25-04-02 |
| 1 | K | 25-04-02 |
I have yet to find how. I've found ideas using "COUNTIF" but it didn't work. Conditional formatting wan't of any help yet.
