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