Identifying duplicates - Microsoft Community

i have merged 2 files one. format simple: 3 columns first name, last name, email address.

the merged file has 1100 rows. 

when delete duplicates in example, automatically tells me there 29 duplicates , deletes them. end result clean file, 29 less rows, , no duplicates.

but ...  want see duplicates ... alone. there way delete rows except duplicates?

ciao,

on workaround can using conditional formatting duplicate findings, sorting colour (so duplicates shown together).

https://www.accountingweb.com/technology/excel/...

please let me know if helps somehow.

ciao
ugo

Office / Excel / Windows 10 / Office 2016