M
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
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