[Spexxvet]

Please help!

I have an Excel spreadsheet with 46,000 rows of information. It is a list of frames, most of which come in multiple sizes and colors. So in column A, there might be 2 to 10 rows with the same entry, with columns b and c listing the sizes and colors.

I want to wean column a so that there is no repetition. How do I eliminate the repeats in column a without manually deleting repeating rows?

Thanks for any help.