Get rid of duplicates in excel using VBA
Loading...
Loading...
3,432
Link to this comment:
Share to:
Uploader Comments (nagileon)
see all
All Comments (4)
-
what if the duplicate is written in a different format like for example, i have JOHN, DOE and DOES JOHN, and JOHN, DOES SR.,,,all are the same people how would i highlight them all.
-
Very good. I have an application for this right away. Thank you.
-
this is a very good tutorial..hope you would still make a lot of tutorials :) i would like to learn a lot about MS excel visual basic..thanks a lot..
Loading...
- 1:48Excel VBA - Collectionsby rstcomputer7,561 views
Featured Video
- 6:57Find Duplicate Information in an Excel Databaseby moderninconveniences2,961 views
- 2:10How To Find Duplicates In Excelby Instruction4U2,630 views
- 6:28How to Merge Multiple Excel Workbooks to a Mast...by DannyRocksExcels36,196 views
- 0:32How to filter for duplicates with Excelby etableutilities2,815 views
- 7:50Creating a simple macro in Excel 2010 - Part 1by learnexcelfunctions70,818 views
- 6:33VBA excel processing databy nagileon2,002 views
- 6:31How to use Conditional Formatting in Excelby excelteacher2,109 views
- 3:45Hack Excel VBA Passwordby mpeplow855136,025 views
- 3:59Excel Magic Trick # 159: VLOOKUP Duplicates 1st...by ExcelIsFun22,917 views
- 0:34How to Delete Duplicates in Excel 2003by MrJfranco795,396 views
- 5:27Consolidate Data in Excel that has Multiple Dup...by ExcelisHell10,234 views
- 9:13VBA Lesson 11 - Populate an array with no dupli...by ExcelVBAHelp8,334 views
- 6:21Send email from excel using VBAby nagileon14,698 views
- 6:19Ackerman Steering Optimization Code: Excel VBAby jlbatey211,609 views
- 4:19Create an Excel UserForm, Part 2 of 3by contextures144,532 views
- 2:35Solve Sudoku with Excel using VBA (simple)by MindDefiner5,058 views
- 7:15Data Analysis in Excel 5 - Remove Duplicate Ent...by ExcelisHell9,044 views
- 1:13Excel 2007 VBA Remove Duplicate Value Using VBAby jiejenn1,326 views
- 0:57Remove Duplicate Records in Excel 2007by contextures20,808 views
would this still function right even if the duplicates are not found on the next rows immediately following the original values? like the original value of row 2 has its duplicate value in row 10..
csibond 3 years ago
No, you must add a For loop checking all rows below the second row.
nagileon 3 years ago