Learn Excel 2010 - "Filter to Unique?": Podcast #1500
Loading...
Loading...
861
views
Loading...
Uploaded by bjele123 on Dec 30, 2011
Today's question... can you use the AutoFilter dropdowns to filter to one row per unique customers? For a solution to this, you can move to the Advanced Filter or use Remove Duplicates on a copy of the data. Follow along with Episode #1500 as Bill shows us both methods.
...This episode is the video podcast companion to the book, "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book!
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
- 7 likes, 1 dislikes
-
- 6:21
Learn Excel 2010 - "Hosted PowerPivot" #1432by bjele1231,611 views
- 12:18
How to Return Either an Approximate or Exact Match with VLOOKUP in Excelby DannyRocksExcels394 views
- 4:37
Learn Excel 2010 - "Picture Lookup": Podcast #1485by bjele123837 views
- 1:58
Learn Excel 2010 - "Numbers to Words in Excel": Podcast #1431by bjele1232,039 views
- 1:48
Hide Pivot Table Detail Without Filteringby contextures362 views
- 1:33
Quickly Find Items in Excel 2010 AutoFilter Listby contextures4,897 views
- 2:48
Excel Drop Downs From List in Different Workbookby contextures2,414 views
- 7:25
How to use Mail Merge with Microsoft Excel 2010 and Microsoft Word 2010by MrPcclean3,195 views
- 3:19
Learn Excel 2010 - "Date Stamp Next to a Yes": Podcast #1474by bjele123761 views
- 18:26
Office 2010 Class #35: Excel Sort and Filter (Data Analysis)by ExcelIsFun11,266 views
- 1:38
Excel Magic Trick 827: Alt + Tab To Switch Between Open Windows (YouTube Video & Excel Workbook)by ExcelIsFun1,013 views
- 6:56
Mr Excel & excelisfun Trick 77: Top Two Customers In Each Industry PivotTable or Sort Filter Formulaby ExcelIsFun2,306 views
- 5:46
SUM SUMIF COUNT COUNTIF - Excel for Business - Lesson 3by raycolondotcom62,538 views
- 4:09
Mr Excel & excelisfun Trick 92: Round Invoice: ROUND or SUMPRODUCT - ROUNDby ExcelIsFun1,378 views
- 5:06
Learn Excel 2010 - "Worksheet Name in Cell": Podcast #1490by bjele1231,078 views
- 2:05
Email Merge with Outlook, Word and Excel 2010by jelfrank2867,874 views
- 4:08
Mr Excel & excelisfun Trick 64: Extract Records With Not Criteria VBA or Filterby ExcelIsFun3,659 views
- 13:15
Building a Pivot Table in Excel 2010 -- Part 3 - Filteringby simonsezittraining7,817 views
- 2:20
Learn Excel 2010 - "Running Total AutoFill": Podcast #1502by bjele123807 views
- 10:47
Mr Excel & excelisfun Trick 42: Lookup Picture In Excel Formula or VBA?by ExcelIsFun25,445 views
Thanks bill, Happy New Year
krn14242 1 month ago
Respected Sir, May the New Year bring Fresh hopes, happiness and prosperity to you and your family. Happy New Year.
MrGopalchouhan 1 month ago
The advanced wouldn't be to bad if you use the automatic copy option too.
dovh49 1 month ago