#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 |
sum of duplicates | zxmax | Excel | 1 | 09-29-2006 08:29 PM |