Is there an opposite of the UNIQUE() function?

[jase71ds]

Hi all,
UNIQUE() is awesome, but im in a situation where I need to find the opposite, I need it to show me what was a duplicate.
Instead of returning a list of unique items, I need Excel to show me which items were duplicates?
So if my list were "Apple", "Apple", "Banana", "Pear"
The return would be "Apple"

Thanks for any help on this.
Jase.

 

[JEC]

=UNIQUE(FILTER(A1:A4,COUNTIF(A1:A4,A1:A4)>1))

 

[jase71ds]

BRILLIANT!!!
Thanks so much!

 

[JEC]

You’re welcome! Cheers