Hi-
I am trying to format a file, which has a list of data that is grouped based on an ID code.
Ex.
001 James
001 Jenny
002 Jimmy
002 Connor
003 Steven
003 Sean
003 Jan
004 Danny
004 Grant
The duplicates would be identified based on their ID# number (ex. 001) and every other set of duplicates needs to be highlighted. Ex. so the 001 & 003 data sets would be highlighted but not the 002 data set.
I am not too familiar with VBA coding, is there a function or set of functions that would allow me to format the data based on the criteria described above?
Bookmarks