Friends,
I have a file with 238 rows and 10 columns (see file attached)
Column G include phone numbers, some phone numbers are duplicated.
How can I use a macro (I must do it with a macro) to delete the ENTIRE row if the value in column G is the same in other row?
For example: look at rows 2 and 3 : the value in column G2 and G3 is the same, therefor delete row 3
(and if the value in G4 was also the same, then delete also row 4, and so on..)
Bookmarks