Thread: [Solved] Finding Duplicates & Unique Values in More Than One Sheet
View Single Post
 
Old 03-05-2020, 09:50 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
I am using my cellphone soI can't work on your attached sample. Try this in B2
=IF(COUNTIF(Sheet1!A$2:$A$14,A2)>0,"TRUE","FALSE")
Copy down.
Reply With Quote