Thread: [Solved] Formula Help
View Single Post
 
Old 10-19-2017, 08:01 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
AND(COUNTIFS($D$2:$D2,$D2)>1,COUNTIFS($E$2:$E2,$E2 )>1)
doesn't actually determine that the duplication happened on the same row for both columns.
Reply With Quote