Do until loop (deleting duplicate values)

[buntalan80]

Hi,

I have an excel sheet list that has duplicate values and want delete the duplicate value. After sorting the list, it looks like the following:

aa 12
aa 13
bb 32
bb 44
cc 34
cc 56

I would like a macro to delete every other value or a smart macro that just deletes the duplicate value (i.e., the variable and not the information appended to the variable) and keeps one of them. After running the macro the new list should look like this:

aa 12
......13
bb 32
.....44
cc 34
.....56

The list can be as long as the row limitation of excel 2010 or as short as 10 rows.