Finding Duplicates & Unique Values in More Than One Sheet

		Microsoft Office Forums > Microsoft Excel > Excel
Finding Duplicates & Unique Values in More Than One Sheet

03-06-2020, 12:13 AM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 949

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Loop through cells and return only unique values	trevorc	Excel Programming	4	10-11-2018 03:49 PM
Sorting cells with duplicates values	allex011	Excel	4	12-27-2017 12:31 PM
Finding Duplicates with Multiple Criteria	balajigade	Excel	2	12-06-2015 10:16 PM
Combining Records of two sheets with Loop till Unique ID	abhilashv	Mail Merge	1	01-22-2014 04:02 AM
If two geographical data match in two sheets, copy unique id/code found in one sheet	alliage	Excel	1	09-01-2011 05:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:54 AM.