Removing duplicate names

[jeff.p]

Hello

Is there a way to remove duplicate names within a row of my worksheet?

As an example row A1 might look like this:


Column

A.......B........C.....D......E......F...G.....H.....I.......J

Bob, Mary, John, John, John, Bill, Bill, Fred, Mike, Mike



to look like this by perhaps by deleting the entire column where the duplicate name appears?



A.......B......C......D.....E.....F...

Bob, Mary, John, Bill, Fred, Mike


Thanks for any help


~Jeff

[VBA Noob]

Is this a cross post ??

http://www.ozgrid.com/forum/showthread.php?t=80886

VBA Noob

[jeff.p]

Not a cross post.

More like part 2 of my original question.



~Jeff

[jeff.p]

ah, finaly found my own answer .


http://www.ozgrid.com/VBA/RemoveDuplicates.htm