473,326 Members | 2,655 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Excel Help!!

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
2 1326
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: steve | last post by:
Hi, I have generated a datagrid with the following columns: | Date-Time | Station ID | Parameter1 | .... | Parameter 2| I would like to: Create an Excel file and preferably give the user...
6
samycbe
by: samycbe | last post by:
Hi Friends, I want to open the excel and show the print dialouge box in excel when a command button click on vb. Please help me samy
6
by: jtswim01 | last post by:
I have a very basic issue in excel and I can't for the life of me find the solution. I have a dense worksheet of data and I want to distill some of the information into a much shorter list. The...
0
by: johnlim20088 | last post by:
Hi, Hi someone can help me on this? Currently I have a Listdata.aspx page with datagrid, I wish to export my datagrid content to excel with following code ( with button export click event):- ...
5
by: Louis | last post by:
I am trying to use php to update a spreadsheet (MS Excel or OpenOffice Calc) with data from MySQL. I looked into PEAR::Spreadsheet_Excel_Writer if it will do the job. If I understand it...
2
budigila
by: budigila | last post by:
Hiya peeps, Okies, I have been trying to work this out for a while now to no avail... I am a beginner to this whole coding thing but have made great strides in my project. Basically what I am...
1
by: JC2710 | last post by:
Hi I have a problem which I cant quite solve. I have a query that groups records together to get a Total Price..... Group....... Total Quantity............Price ...
10
KodeKrazy
by: KodeKrazy | last post by:
I'm trying to read an Excel worksheet and do a find/replace for all of the commas "," in any of the cells in the sheet and replace them with a dash "-" I can get as far as getting the workbook...
0
by: hitencontractor | last post by:
I am working on .NET Version 2003 making an SDI application that calls MS Excel 2003. I added a menu item called "MyApp Help" in the end of the menu bar to show Help-> About. The application...
9
by: MyWaterloo | last post by:
Hi all. I am asking this question here because I have no idea where else to go with it. It involves VBA... but not Access. You guys have always been spot on with Access help so i thought maybe you...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.