I need an excel formular to do advance Exact match and identify same record or different record
I have over 100,000 rows. I have been able to test for duplicate but I want to further check using column A1 and A2; let me know if B1 and B2 are same name but skip to test A3 and A4 to tell me if B3 and B4 are the same. I don't want it to test A2 and A3 because I know they are different.
I need a formular in Excel without vba to achieve this
| Column A | Column B |
|---|---|
| 100000 | Depe |
| 100000 | Depe |
| 200000 | June |
| -------- | -------- |
| 200000 | Baby |
| 200000 | Boy |
| 300000 | May |
| -------- | -------- |
| 300000 | Book |
In cell C1 place this formula
press Enter. Then select C1 and C2, after drag down till the end of the column of data.
Result
Remark: If you insert/delete rows in the data need to copy down again C1-C2, because the inserted/deleted row destroy the pairing after action.