Forum Discussion
Solved
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 / Dupl...
Thank you. This is a perfect match =IFNA("B"&XMATCH(A2,B:B),"")
="B"&MATCH(1,COUNTIF(A:A,B:B),0) keeps having me reboot Excel due to a delay, not sure what the reason is. I'll go with the one above.
I found a formula that worked. I appreciate your time and assistance. Thank you
="B"&MATCH(A2,B:B,0)
="B"&MATCH(A2,B:B,0)
This will only bring you the row in column B that is identical to cell A2. Of course, if you already know that the cell with the duplicate entry is in cell A2, then it can work. My formula also works. Please send a screenshot. PLEASE PLEASE PLEASE