Assume the following:
Column A
Bob
Bob
Tim
Sally
Sally
Sally
Dave
Dave
Jim
I would like to examine the range and send one instance of each name to a new range with no skipping of rows. So Column C would be:
Column C
Bob
Tim
Sally
Dave
Jim
I very much appreciate the help. - AS
Bookmarks