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