Thread: Find duplicates formula
View Single Post
 
Old 10-26-2010, 02:28 AM
Kimberly Kimberly is offline Windows 7 Office 2010 (Version 14.0)
Expert
  
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default
=countifs($a$1:$a$1000,a1,$b$1:$b$1000,b1)
Reply With Quote