Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Looking for duplicates across two files Looking for duplicates across two files
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 11-04-2016, 01:00 PM
macropod's Avatar
macropod macropod is offline Looking for duplicates across two files Windows 7 64bit Looking for duplicates across two files Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,383
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Try:


=IF(F2="","",IF(COUNTIF([Book1.xlsx]ALL!$D:$D,F:F)=0,"New","Duplicate"))
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
in each row mark duplicates roderh Excel Programming 9 09-29-2016 09:01 PM
Sequencing duplicates balajigade Excel Programming 3 10-04-2015 03:31 PM
Looking for duplicates across two files Removing duplicates saurabhlotankar Excel Programming 14 05-26-2015 10:13 AM
Mail duplicates mixy Outlook 0 02-10-2011 12:54 AM
Looking for duplicates across two files sum of duplicates zxmax Excel 1 09-29-2006 08:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:17 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