Good afternoon. I have a dataset that will continually grow. As new records are added, I want to see if duplicate records appear in column 2 and be able to report that these duplicate records cross over into multiple records in column 1. Can someone assist me in two formulas? Many thanks.
| Column1 | Column2 | Do the duplicate records in column2 carry over into multiple records in column1? |
| A | 18 | No |
| A | 45 | Yes |
| A | 177 | Yes |
| A | 50 | No |
| B | 45 | Yes |
| B | 294 | No |
| B | 360 | No |
| C | 177 | Yes |
| C | 45 | Yes |
| Need formula for this unique list of duplicate records | |
| A | 45 |
| B | 45 |
| C | 45 |
| A | 177 |
| C | 177 |
