[MSExcel] Is there a way...

**Whir** · January 23rd, 2003, 11:48 PM

Is there a way to select a column, then have it delete all duplicate cell entries (alpha-numeric data) in the column?

I am ascend sorting them so I can see all the duplicates, I am hoping there is a quick way to delete the dupes instead of doing it by hand.

Thanks.

-Whir

**Brainchild** · January 24th, 2003, 01:41 AM

sorry no help, but ^bump^ for ya

**Whir** · January 24th, 2003, 02:05 AM

Oooh, I figured it out.

Select the column. Go Data -> Filter -> Advanced Filter. Click the unique checkbox and hit okay. Rock on me.

**vass0922** · January 24th, 2003, 03:33 AM

sorry didn't get a chance to reply earlier.. work was a real bear tonight.

I was going to suggest importing into access and doing a select distinct.
I know how much you love sql