Hello Guys,
I have an excel sheet which contains data in around 30 columns. some of the data exists in one column is repeated in other columns also.
I was trying to use Remove duplicate option in Excel but it's not considering all the columns,
Is there any way to with macro to remove duplicates in entire spreadsheet ?
Thanks in advance.
Example Data
[TABLE="border: 1, cellpadding: 1, width: 500"]
[tr][td]A
[/td][td]B
[/td][td]D
[/td][td]A
[/td][td]B
[/td][/tr][tr][td]C
[/td][td]A
[/td][td]C
[/td][td]E
[/td][td]J
[/td][/tr][tr][td]B
[/td][td]F
[/td][td]A
[/td][td]G
[/td][td]L
[/td][/tr][tr][td]G
[/td][td]C
[/td][td]H
[/td][td]C
[/td][td]H
[/td][/tr][tr][td]I
[/td][td]J
[/td][td]K
[/td][td]L
[/td][td]M
[/td][/tr]
[/TABLE]