would like to delete duplicate cells

J

jd

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.
 
J

jd

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.
 
Top