Thread
: [Solved]
Finding Duplicates & Unique Values in More Than One Sheet
View Single Post
03-06-2020, 12:13 AM
ArviLaanemets
Windows 8
Office 2016
Expert
Join Date: May 2017
Posts: 873
Quote:
Originally Posted by
Marcia
=IF(COUNTIF(Sheet1!A$2:$A$14,A2)>0,"TRUE","FALSE")
IF() is not needed.
Code:
=COUNTIF(Sheet1!A$2:$A$14,$A2)>0
will do fine.
ArviLaanemets
View Public Profile
Find all posts by ArviLaanemets