|
|
#1
03-05-2020, 08:28 PM
|
|||
|
|||
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 
|
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode