Hi
lets assume your source list is in A1:A10
now enter the following formulas:
B1: =A1
B2: enter the array formula (committed with cTRL+sHIFT+ENTER):
=INDEX($A$1:$A$10,MATCH(1,COUNTIF($A$1:$A$10,$A$1: $A$10)
*(COUNTIF(B$1:B1,$A$1:$A$10)=0),0))

and copy this down unless you get an error message

--
Regards
Frank Kabel
Frankfurt, Germany

"Julian" schrieb im Newsbeitrag
...
Hi

I need to exclude non-duplicate entries from an excel file (yes,
non-duplicates, not duplicates). Any suggestions?

Thanks