A quicker way than INDEX to count unique values in a list

Hi all,

I am using the formula =INDEX($A$2:$A$5800, MATCH(0, COUNTIF(L1:$L$1, $A$2:$A$5800)+IF(COUNTIF($A$2:$A$5800, $A$2:$A$5800)>1, 0, 1), 0)) to create a list of any duplicate values in the range A2:A5800.

This takes a really long time for excel to process...is there an easier (quicker) way? I played with a pivot table which I am new to, but couldn't work out how to filter only if a value was a duplicate.

Cheers,

Tom

Re: A quicker way than INDEX to count unique values in a list

Don't I feel like the fool...never knew that existed! Thanks so much!