Forum Discussion
Solved
EXCEL - Remove 1st record of Duplicates and retain the remaining records
Hi There. I have an excel table with 3 fields: Email, Date, TOTAL. There are many repeating email addresses, for example abc@gmail.com may have multiple purchases. I would like to remove the fi...
HansVogelaar THANK YOU - You are a star 😊
You can use the same idea, but with a different formula in the Remove column.
If you have Microsoft 365 or Office 2021:
=SUM(--(LEN(UNIQUE(FILTER(B$5:B5,C$5:C5=C5,"")))>0))=1
If you have an older version, use the following array formula, confirmed with Ctrl+Shift+Enter:
=SUM(--(FREQUENCY(IF(C$5:C5=C5,MATCH(B$5:B5,B$5:B5,0)),ROW(B$5:B5)-ROW(B$5)+1)>0))=1
Again, filter for TRUE, remove the remaining rows, then delete the extra column.
HansVogelaar THANK YOU - You are a star 😊