Excel question?

  • Thread starter Thread starter Kenny
  • Start date Start date
K

Kenny

Not strictly XP related but maybe someone here knows the answer. I have a
very large, 25,000 rows x 6 columns, spreadsheet. It's updated occasionally
using Copy & Paste. I believe I have added the same updates more than once.
Is there some way in Excel 2002 I can search for identical/duplicated
entries so that I can remove them?
 
Kenny said:
Not strictly XP related but maybe someone here knows the answer. I have a
very large, 25,000 rows x 6 columns, spreadsheet. It's updated occasionally
using Copy & Paste. I believe I have added the same updates more than once.
Is there some way in Excel 2002 I can search for identical/duplicated
entries so that I can remove them?
Click to expand...

There may be a way to do it in Excel with sorting of the fields. But
for that size of data, I would try first to do it in Access by exporting
the data into a database and use Querys. There is I think a Wizard in
Access to check for duplicate records. At point you can chose to keep
the data in Access (which for such large amount of data may be
beneficial to you), or just put it back into Excel sans the duplicate
records.

Probably best to discuss this further on the Excel and/or Access newsgoups.
 
Thanks for the reply, I only know the very basics of Access so will ask in
Excel and/or Access group.
 
Don't be afraid to experiment.
Thanks for the reply, I only know the very basics of Access so will ask in
Excel and/or Access group.

--

Kenny




newsgoups.
Click to expand...
 
Have you tried find, find next?

--
Just my ¢ worth
Jeff
__________in response to__________
| Don't be afraid to experiment.
|
| Kenny wrote:
|
| > Thanks for the reply, I only know the very basics of Access so will ask in
| > Excel and/or Access group.
| >
| > --
| >
| > Kenny
| >
| >
| > in message | >
| >>Kenny wrote:
| >>
| >>
| >>>Not strictly XP related but maybe someone here knows the answer. I have
| >
| > a
| >
| >>>very large, 25,000 rows x 6 columns, spreadsheet. It's updated
| >
| > occasionally
| >
| >>>using Copy & Paste. I believe I have added the same updates more than
| >
| > once.
| >
| >>>Is there some way in Excel 2002 I can search for identical/duplicated
| >>>entries so that I can remove them?
| >>>
| >>>--
| >>>
| >>>Kenny
| >>>
| >>>
| >>>
| >>
| >>There may be a way to do it in Excel with sorting of the fields. But
| >>for that size of data, I would try first to do it in Access by exporting
| >> the data into a database and use Querys. There is I think a Wizard in
| >>Access to check for duplicate records. At point you can chose to keep
| >>the data in Access (which for such large amount of data may be
| >>beneficial to you), or just put it back into Excel sans the duplicate
| >>records.
| >>
| >>Probably best to discuss this further on the Excel and/or Access
| >
| > newsgoups.
| >
| >
| >
|
 
Highlight the your column headings and use the auto filter feature.
Data\filter\auto filter

HTH

Have you tried find, find next?

--
Just my ¢ worth
Jeff
__________in response to__________
in message | Don't be afraid to experiment.
|
| Kenny wrote:
|
| > Thanks for the reply, I only know the very basics of Access so will ask
in
| > Excel and/or Access group.
| >
| > --
| >
| > Kenny
| >
| >
| > "Rob Schneider" <[email protected]>
wrote
| > in message | >
| >>Kenny wrote:
| >>
| >>
| >>>Not strictly XP related but maybe someone here knows the answer. I
have
| >
| > a
| >
| >>>very large, 25,000 rows x 6 columns, spreadsheet. It's updated
| >
| > occasionally
| >
| >>>using Copy & Paste. I believe I have added the same updates more than
| >
| > once.
| >
| >>>Is there some way in Excel 2002 I can search for identical/duplicated
| >>>entries so that I can remove them?
| >>>
| >>>--
| >>>
| >>>Kenny
| >>>
| >>>
| >>>
| >>
| >>There may be a way to do it in Excel with sorting of the fields. But
| >>for that size of data, I would try first to do it in Access by exporting
| >> the data into a database and use Querys. There is I think a Wizard in
| >>Access to check for duplicate records. At point you can chose to keep
| >>the data in Access (which for such large amount of data may be
| >>beneficial to you), or just put it back into Excel sans the duplicate
| >>records.
| >>
| >>Probably best to discuss this further on the Excel and/or Access
| >
| > newsgoups.
| >
| >
| >
|
 
Excellent idea. Didn't occur to me. Well done. I'd be curious to know
of 25000 records overwhelms things, but a good idea.
 
Back
Top