Problem with removing duplicates

[emil9216]

Hello,

I have data in A and B columns. I have duplicate values in column A which i want to remove. If i try to use "expand the selection" when removing duplicates in A it doesn't remove the duplicates because in column B i have unique values. I want to use "expand the selection" because i want to keep the same order of the adjacent cells in both columns.

I uploaded an example file to make the things more clear.

example.xlsx

In column A i have 3 unique values: red, blue, black.
red has two duplicates, blue has one duplicate, black has four duplicates. I want to remove the duplicates and leave just one unique value in column A. It doesn't matter which unique value will be left, for example, for "red" it can be the value in A2 or A5 or A6 but i want to keep the same value that is in the adjacent cell in column B. For example, if the "red" in A2 is left after removing the duplicates the adjacent cell in column B2 i want to be "color b"

I hope all this makes sense.

[Andrew-R]

Select columns A & B
Click "Remove duplicates"
Untick column B from the list of columns to check
Click "OK"
Job done.

[emil9216]

Thanks, simple solution.