Excel Magic Trick 434: Extract Completed Records with Formula
Loading...
Loading...
5:53
Excel Magic Trick 435: Extract Duplicate Records with Formulaby ExcelIsFun4,711 views- 5:48
Excel Magic Trick 341 Extract Data w OFFSET & INDEX functionby ExcelIsFun13,100 views
- 17:57
Excel Magic Trick 690: Extract Unique Records Based on 2 Columns, List Values Horizontallyby ExcelIsFun1,792 views
- 10:12
Excel Magic Trick 185 Dynamic Formula Extract Data 1criteriaby ExcelIsFun31,173 views
- 6:28
Excel Magic Trick 577: Find Duplicates, Then Extract Unique Recordsby ExcelIsFun10,296 views
- 10:34
Excel Magic Trick 697: Extract Month Year Records From Transactional Data - 3 Methodsby ExcelIsFun1,701 views
- 14:19
Excel Magic Trick 754: Extract Records For Invoices 30 Days Past Due -- Formula Methodby ExcelIsFun2,739 views
- 23:31
Excel Magic Trick 703: Extract Records Multiple Criteria (AND OR logic) Filter, Formula, Adv. Filterby ExcelIsFun8,777 views
- 15:12
Excel Magic Trick 758: Extract Data With Two Criteria - 5 Formula Methodsby ExcelIsFun4,637 views
- 24 videosAdvanced Filter Data Extract
- 9:41
Excel Magic Trick #187: Unique List w Dynamic Formulaby ExcelIsFun14,029 views
- 6:28
Excel Magic Trick 753: Extract Records For Invoices 30 Days Past Due -- Filter Methodby ExcelIsFun2,040 views
- 12:12
Excel Magic Trick 574: Array Formula For Filtering Data With Categories of Criteriaby ExcelIsFun3,559 views
- 11:45
Excel Magic Trick 569: Extract Past Due Loans - Dynamic Formulaby ExcelIsFun1,802 views
- 5:45
Excel Magic Trick 511: Extract First, Middle, Last Names From Bad Data With Extra Charactersby ExcelIsFun3,043 views
- 8:19
Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formulaby ExcelIsFun9,056 views
- 2:01
Excel Magic Trick #226: Apply Names To Formulasby ExcelIsFun2,384 views
- 12:01
Excel Magic Trick 509: VLOOKUP with Dynamic Table using Table Nomenclatureby ExcelIsFun7,554 views
- 12:43
Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formulaby ExcelIsFun22,271 views
- 12:55
Excel Magic Trick 308: Extract Data To New Workbook W Formulaby ExcelIsFun8,383 views
- 9:06
Excel Magic Trick 455: Advanced Filter Macro: Extract Grant Records Under A Cumulative Totalby ExcelIsFun5,217 views
@ronbuller , I have 100s of videos about INDEX and MATCH:
youtube [dot] com/user/ExcelIsFun#grid/user/481C4FC1B5492BAC
ExcelIsFun 2 months ago
hi Mike, nice video, I never thought INDEX would work across worksheets. I sure would like to see more sample videos of INDEX and/or MATCH used across worksheets..
ronbuller 2 months ago
Cool. I am glad that you like it.
ExcelIsFun 2 years ago
Nice vid ;-)
COURSSTATSCHAMBERY 2 years ago