How to Sort and Find duplicates in Excel
Loading...
Link to this comment:
Uploader Comments (juliewolf4assurance)
All Comments (13)
-
thank u so much for this video
it really helped!
-
Great! Thanks!
-
you make it look so easy
-
very good amigo. thx a lot
-
I bet I spent 8 hours messing around with formulas. Then I went out and had a cocktail to melt away my frustration. When I came back I found your video right away. I got lucky. You should write the book formulas for dummies.
Thank you
-
@thuynguyenable yes there is, highlight table, go to home ribbon, conditional formatting, highlight cell rules, duplicate values. This will work on Microsoft excel 2007/2010. hope this helps
-
@thuynguyenable in microsoft office in the "Data" tab, you'll find button that says "Remove Duplicates" all you have to do is to press it and everything will be allright ;) (if you have more columns you'll have to say wich column you want him to verify for duplicates)
-
sorting initially should set it up to avoid that
2:10How To Find Duplicates In Excelby Instruction4U2,630 views
- 1:31How to compare lists / data with Excelby etableutilities8,912 views
- 7:45Keyboard Shortcuts Everybody Should Knowby pcmedianet13,344 views
- 0:17Remove Duplicates in Excel - 15 Second Tutorial...by ExcelTutorials5,049 views
- 4:18How to Create a Searchable Database - Step 1 o...by CaspioInc15,664 views
- 3:27Use Excel's MATCH Function With VLOOKUPby contextures58,886 views
- 4:27How to Find & Remove Duplicate Records in Excel...by DannyRocksExcels4,716 views
- 1:35Excel lookup with multiple conditions! (extende...by Psychotec9,975 views
- 6:57Find Duplicate Information in an Excel Databaseby moderninconveniences2,961 views
- 6:28How to Merge Multiple Excel Workbooks to a Mast...by DannyRocksExcels36,196 views
- 4:46Excel Lookup Series #11: INDEX & MATCH function...by ExcelIsFun65,138 views
- 2:46Comparing lists in spreadsheetsby bjdean423,553 views
- 1:03How to create a flowchart quickly in Excel.by HayaHayaSupport7,951 views
- 4:54Excel Magic Trick 398: VLOOKUP with Two Lookup ...by ExcelIsFun30,602 views
- 7:01Excel: Drop-Downs(Combo Box) and Conditional Fo...by iProRyan28,052 views
- 10:50Vlookup Excel Bestby rdjalayer136,614 views
- 5:53Compare Two Excel Lists to Spot the Differencesby DannyRocksExcels22,747 views
- 0:32How to filter for duplicates with Excelby etableutilities2,815 views
- 7:00Excel Sorting and Filteringby TheExcelOffice1,544 views
- 4:07SUMIF and COUNTIF functions in Excelby AuditExcel27,175 views
You should have a donate link.
Thank you so much.
rageatm111 1 year ago
Thank YOU! Good idea. Skype me to help me set one up? PayPal has?
juliewolf4assurance 1 year ago
Dear who has posted this video,
It's really a helpful way to find duplicates. It seems that it still has a limited use. In your video, two duplicated words "Art65" stand next to each other so the formula worked well.But if these duplicate words do not stand next to each other, for example, one word in row 2 and the other word in row 5, it will say "False", which means this formula will not discover the duplicate words.
Is there any way to fix that? Thanks. dvance.
thuynguyenable 2 years ago
I do not think so, but will ask Russ to comment.
juliewolf4assurance 1 year ago