Thread: [Solved] Finding Duplicates & Unique Values in More Than One Sheet
View Single Post
 
Old 03-05-2020, 08:28 PM
Karen615 Karen615 is offline Windows 7 64bit Office 2010 64bit
Competent Performer
  
Join Date: Jun 2011
Location: Chicago
Posts: 112
Karen615 is on a distinguished road
Default 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
File Type: xlsx Excel Sample.xlsx (10.4 KB, 8 views)
Reply With Quote