Finding Duplicates & Unique Values in More Than One Sheet

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

FAQ

Thread Tools

Display Modes

03-05-2020, 08:28 PM

Karen615

Windows 7 64bit Finding Duplicates & Unique Values in More Than One Sheet

Office 2010 64bit

Competent Performer

Join Date: Jun 2011

Location: Chicago

Posts: 145

Finding Duplicates & Unique Values in More Than One Sheet

Using Excel 365

Please see attached.

I would like to know how to set up a formula/function in Sheet2, cell B2 that will search column A in Sheet1. If a company in Sheet1 matches a company in Sheet2, it will return TRUE or FALSE.

For Example-Sheet2:
Cell B2: FALSE
Cell B3: TRUE

Cell B4: FALSE

Your help is greatly appreciated.

Karen

Attached Files

Excel Sample.xlsx (10.4 KB, 10 views)

« Previous Thread | Next Thread »

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 05:54 PM.