HI trying to find the fastest way i can find duplicate numbers in column BQ. Meaning i have like 500 lines of numbers in BQ. Just want to find out whats duplicting. So if 6 and 6 are in column BQ i want to know this in a quick way.
=COUNTIF($BQ$1:$BQ$500,$BQ1)>1
You mean I have been doing it the hard way over all these years!?!?!The built in rule will do the same without the formula - "Format only Unique or Duplicate values" then select Duplicate.