Hello,
i have a worksheet having A-Z columns which contain many such duplicates which are the same through all columns as if one had copied the whole row. I would like to delet all duplicate rows. For example:
A---------B-----------C------------D----------...Z
love------luv---------noun---------mina-------...muha
love------luv---------noun---------mina-------...muha
love------luv---------noun---------mina-------...muha
love------()----------noun---------mina-------...muha
love------luv---------verb---------mina kawal--...ishq
love------luv---------verb---------mina kawal--...ishq
love------luv---------feal----------mina kawal--...ishq
should look after running a macro as follow:
A---------B-----------C------------D----------...Z
love------luv---------noun---------mina-------...muha
love------()----------noun---------mina-------...muha
love------luv---------verb---------mina kawal--...ishq
love------luv---------feal----------mina kawal--...ishq
So only those duplicates should be deleted which are duplicates from A-Z.
Thank you very much for each help in advance.
Bookmarks