Solved

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

Posted on 2014-09-23
3
356 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:murbro
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:murbro
ID: 40339787
thanks
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

762 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now