Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2014, 05:23 AM
mnut mnut is offline Adding duplicates as comments Windows XP Adding duplicates as comments Office 2003
Novice
Adding duplicates as comments
 
Join Date: Oct 2014
Posts: 2
mnut is on a distinguished road
Default Adding duplicates as comments


Hello!

I have two sheets, one is a diagram of peoples jobs the other is a list of names against job numbers.

Using the below formula the jobs are populated by the names of the workers, however there are duplicates (more workers than jobs).
=IF(ISNA(VLOOKUP(R36,'Nom Roll'!$I$3:$K$65536,3,FALSE)),"VACANT",VLOOKUP(R36 ,'Nom Roll'!$I$3:$K$65536,3,FALSE))

I need a bit of code that will trawl the list identify duplicates, put the duplicate names into a comment on the cell with the above formula and finaly turn the cell red.

Sorry if its a bit basic, anyone have any ideas?
Thanks in advance.
Mike
Reply With Quote
  #2  
Old 10-17-2014, 10:05 PM
macropod's Avatar
macropod macropod is offline Adding duplicates as comments Windows 7 64bit Adding duplicates as comments Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

If you're going to use a macro for adding the duplicates to the cell comments, you may as well forego the formula entirely and use the macro to handle all the processing, perhaps tied to a selection_change event intersecting the data range, so the data are kept current.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding duplicates as comments find and delete duplicates rcVBA Word VBA 4 05-15-2013 03:08 PM
Mail duplicates mixy Outlook 0 02-10-2011 12:54 AM
Adding duplicates as comments Inbox and subfolder duplicates JoJo Outlook 1 01-28-2011 04:39 PM
Find duplicates formula hannu Excel 2 10-26-2010 02:48 AM
Adding duplicates as comments 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 09:15 AM.


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