Donate SIGN UP

Excel help!

Avatar Image
katiesara | 21:26 Tue 11th Feb 2003 | Technology
9 Answers
I've got a spreadsheet containing 1000's of postcodes, loads of them are repeated, is there a way I can delete the repeated entries quickly? Thanks
Gravatar

Answers

1 to 9 of 9rss feed

Best Answer

No best answer has yet been selected by katiesara. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Have you tried using the 'Autofilter' and 'Advanced Filter..' in the 'Data' menu?
Question Author
I did think about it, but I thought that was for only returning data with values that you specified, if I'm wrong please tell me!
You are right, but it's also another way of viewing repeated data and deleting it, depending on how your spreadsheet is set out. At least I have used it this way a few times.
How is your spreadsheet set out?
Question Author
just as a huge page of postcodes entered into cells, about 80 columns x 80 rows, no headers, or anything sensible! It's how the info was given to me, and unfortunately I had no control over that!
[Sorry - it's our policy to remove email addresses from answers for privacy and security reasons - meaning this answer is now redundant! AB Editor]
Hmmm! 'katiesara' I was offering to sort the file for you (no charge of course! as I have a fair bit of spare time and am up for a challenge.), but obviously couldn't post the email address for contacting me. The offer still stands, but not sure the best way of contacting each other!?!
Question Author
It was a very kind offer, thanks anyway!
'katiesara', It's fine to send the file. I'll let you know when I get it.
'katiesara', If you still want the file sorting try going through http://www.galesjam.co.uk
;-)

1 to 9 of 9rss feed

Do you know the answer?

Excel help!

Answer Question >>