Formula to reveal the row number of where the duplicate value is located
Please help! Last week I found an excellent formula and now am kicking myself for not saving it.
I’m working on a large spreadsheet. On 2 columns, I have run the Conditional Formatting / Duplicate Values and highlighted the duplicates. I need the formula to add the Row Number where the duplicate is located.
Example: 2 columns referred to as A and B. In column C, I want to add the formula that shows the duplicate value is on B20001.
Please help! Last week I found an excellent formula and now am kicking myself for not saving it. I’m working on a large spreadsheet. On 2 columns, I have run the Conditional Formatting / Duplicate Values and highlighted the duplicates. I need the formula to add the Row Number where the duplicate is located. Example: 2 columns referred to as A and B. In column C, I want to add the formula that shows the duplicate value is on B20001. Read More
