6:58Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every "Nth" Item, 3 Formula Methodsexcelisfun24.6K viewsView & Download
2:27Excel Magic Trick 1187: Formula to Lookup Every 5th Item In a Column, INDEX and ROWS functionsexcelisfun7.2K viewsView & Download
12:54Excel Magic Trick 1373: Formula to Extract Every Nth Value & Conditionally Format Every Nth Valueexcelisfun119.4K viewsView & Download
2:45Extract All Digits from Range & List in Column - Excel Magic Trick 1812 #shortsexcelisfun7.6K viewsView & Download
6:21Excel Magic Trick 700: Return Every Other Cell (Cell Reference That Skips Columns) INDEX Functionexcelisfun21.6K viewsView & Download
4:30Excel Magic Trick 377: Add Every Other Number In Range of Cellsexcelisfun41.3K viewsView & Download
2:43Excel Magic Trick 947: Defined Name 3-D Cell Reference For Making Calculations Across Sheetsexcelisfun4.7K viewsView & Download
15:08Excel Magic Trick 1009: Lookup 3 Different Arrays From 3 Different Tables: VLOOKUP, CHOOSE, INDEXexcelisfun26.5K viewsView & Download
5:31Excel Magic Trick 419: Add Two Largest, But Skip Columns C & Eexcelisfun15.8K viewsView & Download
17:44Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula)excelisfun51.6K viewsView & Download
5:34Excel Formula to Lookup Nth Value. FILTER, AGGREGATE or SMALL Function? Excel Magic Trick 1727.excelisfun11.3K viewsView & Download
5:49Excel Magic Trick 466: SUM every Nth value SUMPRODUCT, MOD & ROW functionsexcelisfun26.0K viewsView & Download
3:38Amazing XLOOKUP Formula with Lookup Value From Within Description: Excel Magic Trick 1860excelisfun11.2K viewsView & Download
9:01Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula?excelisfun1.2M viewsView & Download
5:03Get Last 5 in Column, Then Add, Average & Display. Six Amazing Examples. Excel Magic Trick 1650.excelisfun17.6K viewsView & Download