Thread: Highliting Duplicate Cells across multiple rows
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John James
 
Posts: n/a
Default Highliting Duplicate Cells across multiple rows

The check to see the cell is blank isn't necessary. Therefore the
formula can be simplified to:

=COUNTIF($1:$65536,A1)-COUNTIF(A:A,A1)<0


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=532633

Reply With QuoteReply With Quote