You are here: Home | Forum | Yet another Excel question!!
You are currently viewing our boards as a guest which gives you limited access to view most of the discussions, articles and other free features. By joining our Virgin Media community you will have full access to all discussions, be able to view and post threads, communicate privately with other members (PM), respond to polls, upload your own images/photos, and access many other special features. Registration is fast, simple and absolutely free so please join our community today.
I have a spreadsheet with 30,000 entries on it, but quite a few of these are duplicates. Is there anyway I can make all the duplicates disappear! and just be left with one of each entry?
is this any help? (Found by searching Excel help for "duplicate")
__________________
Oh Oh Ranje
We houden allemaal van jou, de spelers en het rood wit blauw.
------------------------------------------------------------------------
I wish I knew where I was going, cause I have to get back as well.
Services: NTL Free Phone line
NTL Analog TV
NTL 2MB Broadband line
XBOX 360
Posts: 497
Re: Yet another Excel question!!
just for future references, a program called ASAP utilities, is a great add on for MS Excel.
It has lots of interesting things in it and makes life a whoile lot easier: http://www.asap-utilities.com/
Join CF
You are here: 
Don't I feel stupid!
