Excel Magic Trick 577: Find Duplicates, Then Extract Unique Records
Loading...
Uploader Comments (ExcelIsFun)
All Comments (18)
-
send to excelisfun[at]gmail[dot]com.
-
How do I do that(send youtube email), and can I attach an example there?
-
I still am unclear about what you are trying to do. You can send a YouTube e-mail to me and explain your situation in more detail and I will try to help.
-
I just watched these tutorials you recommended and it is kind of what I'm trying to do but not exactly.
in my case I need to make a new work sheet with the same info as the other, only organized as groups.
once again thank you for all your amazing tutorials and all your help.
-
If it is just EVA try these videos:
Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula
Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula
Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula
-
If it is just EVA try these videos:
Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula
Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula
Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula
-
So you want just Eva's, Mike's sales and take them from Column C and place them in a row?
Or are there two criteria, like Eva and Quad, Exa and Carlota, etc?
-
@ExcelIsFun sorry,
I meant,to look at Eva and consolidate to one or more cell(so I can compare later)
all her sales,as text from the C column.
Thanks,
4:13
Excel Magic Trick 578: Formula To Grade Student Answer Where More Than One Possibility Existsby ExcelIsFun2,550 views- 3:28
Excel Magic Trick 432: Find & Extract Duplicate Recordsby ExcelIsFun6,064 views
- 7:36
Excel Magic Trick 575: Conditional Formatting & Counting with 3 Criteria & Find Formula Mistakesby ExcelIsFun3,672 views
- 1:46
Excel Magic Trick 570: Remove Duplicate Records Excel 2007 / 2010 Featureby ExcelIsFun6,352 views
- 7:34
Excel Magic Trick 606: INDEX & MATCH Two Lookup Valuesby ExcelIsFun15,031 views
- 0:32
How to filter for duplicates with Excelby etableutilities3,227 views
- 8:33
Excel Magic Trick 564: Daily Gantt Chartby ExcelIsFun15,500 views
- 6:57
Find Duplicate Information in an Excel Databaseby moderninconveniences3,980 views
- 6:11
Break Even Analysisby ADMCVideos30,509 views
- 6:26
Excel Magic Trick 382: Match Two Lists, Extract Column Data From Each Listby ExcelIsFun24,440 views
- 4:12
How to quickly find duplicate data in Excelby YVAmmangen12,321 views
- 6:39
Excel Magic Trick 550: Data Validation List Drop-Down Based On 2nd Data Validation List Drop-Downby ExcelIsFun22,309 views
- 2:57
How to Sort and Find duplicates in Excelby juliewolf4assurance28,000 views
- 11:33
Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Throughby ExcelIsFun11,544 views
- 7:17
Excel Magic Trick 528: Check Two Lists For Discrepancies MATCH and VLOOKUP functionsby ExcelIsFun11,266 views
- 12:01
Excel Magic Trick 509: VLOOKUP with Dynamic Table using Table Nomenclatureby ExcelIsFun7,370 views
- 2:10
How To Find Duplicates In Excelby Instruction4U3,396 views
- 8:21
Excel Magic Trick 572: COUNTIF & SUMIFS functions & Logical Formulas have Different Syntaxby ExcelIsFun5,061 views
- 4:52
Excel Magic Trick 533: Date/Time Calculation excluding Holidays & Weekendsby ExcelIsFun6,112 views
How to insert dynamic dropdwon calender and time.
ss1fusion1 11 months ago
I do not know. Try THE best Excel question site:
mrexcel[dot]com/forum
ExcelIsFun 11 months ago