Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 390
  • Last Modified:

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

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
Murray Brown
Asked:
Murray Brown
1 Solution
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
I'm confused - how are you trying to do this? In Excel, in Excel VBA, or in VB.Net? Please elaborate.
0
 
Glenn RayExcel VBA DeveloperCommented:
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
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
thanks
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now