Delete Duplicate Colums based on row content

[Armitage2k]

Hi,

I am trying to figure a way to loop through all cells in range F15:GV15, and in case any of these values is double existing, delete the entire column of the later record.

Anyone who can help with that?

Thanks,
A2k

[zbor]

How about this:

Please Login or Register  to view this content.

[Vikas_Gautam]

Here are the steps:-
1. You can copy the Range F15:GV15 and paste Transpose.
2. Use Remove Duplicate Button to remove Row Duplicates.
3. After that, Paste it back transpose.