would like to delete duplicate cells

I have a huge column of duplicate numbers, anywhere from 1 to 19 duplicates
per number.
would like to clean the column up so only one of each number is showing.
Thanks very much.

Take a look at

http://cpearson.com/excel/deleting.h...eDuplicateRows

In article <OrpZ3$MeFHA.1600@tk2msftngp13.phx.gbl>,
"jd" <jdumont@@novuscom.net> wrote:

> I have a huge column of duplicate numbers, anywhere from 1 to 19 duplicates
> per number.
> would like to clean the column up so only one of each number is showing.
> Thanks very much.

Make a Pivot Table out of them.

Thanks! I got it to work. I'm a real dunce with excel but after a few days
I figured out how to bring up the vba editor and paste the script and run
it. I even saved it as a .bas file. Now I just import the file and run it.

"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-EFC00C.09280124062005@msnews.microsoft.com...
> Take a look at
>
> http://cpearson.com/excel/deleting.h...eDuplicateRows
>
> In article <OrpZ3$MeFHA.1600@tk2msftngp13.phx.gbl>,
> "jd" <jdumont@@novuscom.net> wrote:
>
> > I have a huge column of duplicate numbers, anywhere from 1 to 19
duplicates
> > per number.
> > would like to clean the column up so only one of each number is showing.
> > Thanks very much.