Solved

Excel VB.net  and SQL Check for duplicates in two columns before uploading

Posted on 2014-09-23
3
380 Views
Last Modified: 2014-09-23
Hi

I have a spreadsheet containing where I need to check for duplicate rows where a date in column A and a text item in column D are equal
The first thought is to loop through all items and check each line against this but this will take far too long
0
Comment
Question by:Murray Brown
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40338743
I'm confused - how are you trying to do this? In Excel, in Excel VBA, or in VB.Net? Please elaborate.
0
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
ID: 40339623
In Excel only:

If you want to remove duplicate values WITHIN each column, you can use the built-in "Remove Duplicates" tool.  This is incredibly fast and efficient.
1) Select the entire column (click on the column letter)
2) Menu: Data - Data Tools group - "Remove Duplicates"
2b) If prompted with a "Remove Duplicates Warning" dialog box, select "Continue with the current selection", then click the "Remove Duplicates" button
- Repeat this for each column.
------------------------------------------------
If you have a different issue or request, please elaborate.

Regards,
-Glenn
0
 

Author Closing Comment

by:Murray Brown
ID: 40339787
thanks
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question