Excel Magic Trick 581: Unique List With Criteria Using Advanced Filter
Loading...
Loading...
7:48
Excel Magic Trick 582: Excel Errors 9 Types - What They Mean - How To Fix Themby ExcelIsFun2,637 views- 6:03
Excel Magic Trick 580: Extract Digits To Right Of Decimal Into Individual Cellsby ExcelIsFun1,883 views
- 6:35
Excel Magic Trick 583: AVERAGEIF & IFERROR functions Mixed Cell References Gross Profit Percentageby ExcelIsFun4,342 views
- 1:51
Excel Magic Trick 660: Advanced Filter Unique Records Onlyby ExcelIsFun3,954 views
- 6:56
Excel Dynamic Chart #11: Dynamic Area Chart with IF Function - Normal Distribution Chart Statisticsby ExcelIsFun15,724 views
- 4:27
How to Find & Remove Duplicate Records in Excel 2007by DannyRocksExcels5,693 views
- 9:45
Excel Magic Trick 584: Dynamic Range for Periodic Data Dumps into Excel OFFSET & Defined Namesby ExcelIsFun6,159 views
- 1:52
Free Excel Personal Budget Templateby cogniview85,901 views
- 4:03
Excel Magic Trick 593: Mondays Only Data Validation using Custom Formula with WEEKDAY functionby ExcelIsFun3,345 views
- 3:18
Excel Magic Trick 598: Hours Worked In Day Including Lunch Breaksby ExcelIsFun4,352 views
- 51:50
Excel Magic Trick 627: FREQUENCY Array Function (10 Examples)by ExcelIsFun6,829 views
- 11:33
Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Throughby ExcelIsFun12,023 views
- 3:56
Excel Magic Trick 684: VLOOKUP 1 item & Add Values from Multiple Rows/Columns - HLOOKUPby ExcelIsFun8,062 views
- 2:30
Excel Magic Trick #244: Advanced Filter Extract To New Sheet (Word Criteria)by ExcelIsFun8,471 views
- 5:43
Excel Magic Trick 590: Nested IF function Convert From Actual Days to Billed Daysby ExcelIsFun4,540 views
- 3:23
Excel Magic Trick 600: Convert Hours to Days & Hours using MOD & INT functionsby ExcelIsFun3,376 views
- 10:45
How to Use Advanced Filters in Excelby DannyRocksExcels21,087 views
- 3:44
Excel Magic Trick 594: How Old Are You? DATEDIF Functionby ExcelIsFun4,294 views
- 11:06
Excel Magic Trick 608: Array Formula To Return Multiple Items - List Students With Free Periodsby ExcelIsFun6,619 views
- 4:36
Excel Magic Trick 640: VLOOKUP and Conditional Formatting to Highlight Row with Low Rankby ExcelIsFun5,394 views
I am a sucker too!! I love those array formulas!
ExcelIsFun 1 year ago
@ExcelIsFun Or a sucker for punishment. :)
krn14242 1 year ago
You like the arrary formulas more!? That makes you a true Excel Guru!!!
ExcelIsFun 1 year ago
Thanks Mike, looks like alot of work, I prefer the criteria extract formulas. :)
krn14242 1 year ago