Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Finding Duplicates & Unique Values in More Than One Sheet Finding Duplicates & Unique Values in More Than One Sheet
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 03-05-2020, 09:50 PM
Marcia's Avatar
Marcia Marcia is offline Finding Duplicates & Unique Values in More Than One Sheet Windows 7 32bit Finding Duplicates & Unique Values in More Than One Sheet Office 2013
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 554
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
I am using my cellphone soI can't work on your attached sample. Try this in B2


=IF(COUNTIF(Sheet1!A$2:$A$14,A2)>0,"TRUE","FALSE")
Copy down.
Reply With Quote
  #2  
Old 03-06-2020, 12:13 AM
ArviLaanemets ArviLaanemets is offline Finding Duplicates & Unique Values in More Than One Sheet Windows 8 Finding Duplicates & Unique Values in More Than One Sheet Office 2016
Expert
  
Join Date: May 2017
Posts: 960
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Quote:
Originally Posted by Marcia View Post
=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.
Reply With Quote
  #3  
Old 03-06-2020, 12:22 AM
Marcia's Avatar
Marcia Marcia is offline Finding Duplicates & Unique Values in More Than One Sheet Windows 7 32bit Finding Duplicates & Unique Values in More Than One Sheet Office 2013
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 554
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Right Arvi. Thank you.
Reply With Quote
  #4  
Old 03-06-2020, 09:53 PM
Karen615 Karen615 is offline Finding Duplicates & Unique Values in More Than One Sheet Windows 7 64bit Finding Duplicates & Unique Values in More Than One Sheet Office 2010 64bit
Competent Performer
Finding Duplicates & Unique Values in More Than One Sheet 		 
Join Date: Jun 2011
Location: Chicago
Posts: 145
Karen615 is on a distinguished road
Default
Thank you both for your help!


Karen
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding Duplicates & Unique Values in More Than One Sheet Loop through cells and return only unique values trevorc Excel Programming 4 10-11-2018 03:49 PM
Finding Duplicates & Unique Values in More Than One Sheet Sorting cells with duplicates values allex011 Excel 4 12-27-2017 12:31 PM
Finding Duplicates & Unique Values in More Than One Sheet Finding Duplicates with Multiple Criteria balajigade Excel 2 12-06-2015 10:16 PM
Finding Duplicates & Unique Values in More Than One Sheet 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 04:12 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft