Thanks for the help. I did put them all into the one column with headers and =COUNTIF($A$1:$A$100,A1)>1 and although it's not as elegant as I'd hoped it works just fine.

Cheers.