By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,491 Members | 858 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,491 IT Pros & Developers. It's quick & easy.

Excel Help!!

P: n/a
I currently have a spreadsheet with more than 1000 records. Within
this spreadsheet are many duplicates. In the past I've been using he
filter feature to find the duplictes. However, as the spreadsheet
getts longer that is becoming more difficult. Is there any other way
to delete the duplicates and keep the unique the values?

Please respond through the site as I will not be responding to any
presonal emails. Thanks in advance!!
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 13 Oct 2004 10:33:57 -0700, nikkii wrote:
I currently have a spreadsheet with more than 1000 records. Within
this spreadsheet are many duplicates. In the past I've been using he
filter feature to find the duplictes. However, as the spreadsheet
getts longer that is becoming more difficult. Is there any other way
to delete the duplicates and keep the unique the values?

Please respond through the site as I will not be responding to any
presonal emails. Thanks in advance!!


You have posted this message to the wrong news group.
The access in this newsgroup's title refers to Microsoft Access, a
database product.

I would suggest you re-post to the appropriate Excel news group.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2

P: n/a
Nikki,
Yes, mostly. Access can use Excel spreadsheets as if they were Access
tables. You can then use the query tool of Access to create SQL statements
(queries) that will help you identify duplicates. I'd probably link to a
source worksheet with the data in it's original messy form. Then I'd view
my worksheet in Access with the duplicates suppressed. Once I'd had a
chance to review the results and fix any issues I'd take that and put it in
a results worksheet in the same workbook.

"nikkii" <jo******@aetna.com> wrote in message
news:bd**************************@posting.google.c om...
I currently have a spreadsheet with more than 1000 records. Within
this spreadsheet are many duplicates. In the past I've been using he
filter feature to find the duplictes. However, as the spreadsheet
getts longer that is becoming more difficult. Is there any other way
to delete the duplicates and keep the unique the values?

Please respond through the site as I will not be responding to any
presonal emails. Thanks in advance!!

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.