Excel Magic Trick 676: Defined Name Dynamic Range Formula (column number varies) INDEX Function
Loading...
Loading...
2,930
Loading...
6:49
Excel Magic Trick 675: Double VLOOKUP Custom Formula Dynamic Data Validationby ExcelIsFun8,546 views- 8:25
Excel Magic Trick 677: AVERAGE Last 3 Scores -- Mr Excel Message Board Array Formulaby ExcelIsFun920 views
- 6:08
Excel Magic Trick 678: SUM only Values After Deadline Dynamic Range using INDEX Function.by ExcelIsFun1,201 views
- 14:17
Excel Magic Trick 709: Defined Name Dynamic Range Formula w Relative References & Data Extractby ExcelIsFun2,561 views
- 4:46
Excel Magic Trick 646: VLOOKUP to add column of categories to Apparel Data Setby ExcelIsFun2,432 views
- 4:02
Range Name in Calculations - Excel 2007by cybertechlib674 views
- 2:15
Creating a Drop Down List in Excel 2010by aqueity11,897 views
- 17:52
Excel Magic Trick 698: Extract Unique Items w Formula For Data Validation Drop-Down Listby ExcelIsFun6,112 views
- 8:12
Excel Magic Trick 714: Three Criteria Lookup Adding SUMIF, INDEX, MATCH, SUMPRODUCT (2 examples)by ExcelIsFun6,104 views
- 5:18
Create a Named Range in Excel That Grows Automaticallyby contextures13,581 views
- 23:31
Excel Magic Trick 703: Extract Records Multiple Criteria (AND OR logic) Filter, Formula, Adv. Filterby ExcelIsFun9,097 views
- 8:01
Excel Magic Trick 650: Formula To Extract All Rows In Data Set Into 1 Column INDEX functionby ExcelIsFun3,532 views
- 7:18
Excel Magic Trick 708: Lookup Multiplying -- SUMPRODUCT, Boolean, & INDEX MATCH solutionby ExcelIsFun2,206 views
- 7:31
Excel Magic Trick #240: Dynamic Range New Data At Topby ExcelIsFun4,503 views
- 6:57
Excel Magic Trick 736: Formula & Conditional Formatting To Show Waste From Cutting Rebarby ExcelIsFun1,793 views
- 7:38
Excel Magic Trick 696: Identify First Occurrence In Column (5 methods)by ExcelIsFun1,062 views
- 3:01
Excel Magic Trick 694: SUMIF Can't Handle Arrays. SUMIF(YEAR(A2:A10),2010,B2:B10) Won't Workby ExcelIsFun2,048 views
- 14:49
Excel Dynamic Chart #10: OFFSET Function Dynamic Rangeby ExcelIsFun36,803 views
- 5:50
Excel Magic Trick 706: Extract Number From Cell With A Time, A Dash and A Numberby ExcelIsFun1,976 views
- 3:15
Excel Lookup Series #9: INDEX function 1st Exampleby ExcelIsFun58,673 views
I do not have videos on this topic, Try THE best Excel question site:
mrexcel[dor]com/forum
ExcelIsFun 7 months ago
What I want to do is, chart 1st, 2nd, or 3rd... consecutive 3 or 4 or 5..columns. How do you recommend I proceed?
PastorDaddyJ 7 months ago
I don't think so. INDEX is delivering a cell reference in this case.
What do you have in mind for the COUNTA?
ExcelIsFun 1 year ago
Mike hi, would counta work instead of index+match?
denisrapp 1 year ago
Thanks1 I am glad that you like them!
ExcelIsFun 1 year ago
great video!sir u r great
udanial 1 year ago