Good evening all.
I have learned how to delete rows based on a specific value. I am now stuck on how to delete rows based on duplicate values. For example, if row x = red and row x+1 = red, then I would like the Macro to leave the row x and delete row x+1.
In the sample data attached, the duplicate values are geographic countries. As mentioned before, I can delete the data based on a specific value. For example, if I wanted to delete Algeria from the list, my macro is as follows:
Please how would I adjust this sub routine to do a For next loop where it reads the first country, skips, and then deletes the following rows with duplicate countries. The attached has a before and after if that helps. Many thanks.
Bookmarks