How to remove duplicate rows containing same data

[Mark Christensen]

I've got a sheet with 1410 row, but there may be only 100-150 unique entries
in column A (columns B-C have varying data, thus the repeating of the same
data in column A). I want to distill the sheet down so that there is only
the same number of rows that there is unique entries in column A. Is there
a formula or conditional formatting that will do this?

Example:

A123 Apple Red
A123 Apple Green
A123 Apple Yellow

I don't want 3 rows with A123 in column A - I only want 1 row. I don't care
about saving the data in the other columns. Thanks.

Mark

 

[Mark Christensen]

Nevermind, I just found KB article Q262277. The 1 time I didn't look there
first!