Excel question

Spexxvet · 05-25-2010, 02:17 PM

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.

05-25-2010, 02:17 PM	#1
Spexxvet Makes some feel uncomfortable Join Date: Dec 2005 Posts: 10,346	Excel question 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. __________________ "I'm certainly free, nay compelled, to spread the gospel of Spex. " - xoxoxoBruce

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)