Media Summary: Thanks to Enny Kraft at YouTube for this trick! Related Videos: Also see: Trick 1246: Counting with Case Sensitive Criteria: EXACT & SUMPRODUCT

Excel Magic Trick 1084 Isodd - Detailed Analysis & Overview

Thanks to Enny Kraft at YouTube for this trick! Related Videos: Also see: Trick 1246: Counting with Case Sensitive Criteria: EXACT & SUMPRODUCT

Photo Gallery

Excel Magic Trick 1084: ISODD or ISEVEN Functions to Help Add Every Other Column
Excel Magic Trick 992: Partial Text Criteria for a Number, SUMIF Won't Work
Excel Magic Trick 1484: LOOKUP & Sorted Helper Column: Lookup Price Based on Effective Date
Excel Magic Trick 1104: Add with 6 Criteria (AND and OR Criteria) with Criteria/Data Mismatch
Excel Magic Trick 1082: SUM Every Other Column: Four Formula Methods (Add Every Other Column)
Excel Magic Trick 1085: How To Simulate VLOOKUP Helper Column In Array Formula (Number or Text)
Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables
Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together
Excel Magic Trick 1248: Add or Count Case Sensitive Contains Criteria: ISNUMBER, FIND, SUMPRODUCT
Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP
Excel Magic Trick 778: INDEX & MATCH Lookup Functions Beginning To Advanced (18 Examples)
Excel Magic Trick 1448: Conditional Formatting Formulas: Cell References To “Jump” To Next Template
Sponsored
Sponsored
View Detailed Profile
Excel Magic Trick 1084: ISODD or ISEVEN Functions to Help Add Every Other Column

Excel Magic Trick 1084: ISODD or ISEVEN Functions to Help Add Every Other Column

Download

Excel Magic Trick 992: Partial Text Criteria for a Number, SUMIF Won't Work

Excel Magic Trick 992: Partial Text Criteria for a Number, SUMIF Won't Work

Download

Sponsored
Excel Magic Trick 1484: LOOKUP & Sorted Helper Column: Lookup Price Based on Effective Date

Excel Magic Trick 1484: LOOKUP & Sorted Helper Column: Lookup Price Based on Effective Date

Thanks to Enny Kraft at YouTube for this trick! Related Videos:

Excel Magic Trick 1104: Add with 6 Criteria (AND and OR Criteria) with Criteria/Data Mismatch

Excel Magic Trick 1104: Add with 6 Criteria (AND and OR Criteria) with Criteria/Data Mismatch

Download

Excel Magic Trick 1082: SUM Every Other Column: Four Formula Methods (Add Every Other Column)

Excel Magic Trick 1082: SUM Every Other Column: Four Formula Methods (Add Every Other Column)

Download

Sponsored
Excel Magic Trick 1085: How To Simulate VLOOKUP Helper Column In Array Formula (Number or Text)

Excel Magic Trick 1085: How To Simulate VLOOKUP Helper Column In Array Formula (Number or Text)

Download

Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables

Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables

Download

Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together

Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together

Download

Excel Magic Trick 1248: Add or Count Case Sensitive Contains Criteria: ISNUMBER, FIND, SUMPRODUCT

Excel Magic Trick 1248: Add or Count Case Sensitive Contains Criteria: ISNUMBER, FIND, SUMPRODUCT

Also see: Trick 1246: Counting with Case Sensitive Criteria: EXACT & SUMPRODUCT

Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP

Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP

Download

Excel Magic Trick 778: INDEX & MATCH Lookup Functions Beginning To Advanced (18 Examples)

Excel Magic Trick 778: INDEX & MATCH Lookup Functions Beginning To Advanced (18 Examples)

Download

Excel Magic Trick 1448: Conditional Formatting Formulas: Cell References To “Jump” To Next Template

Excel Magic Trick 1448: Conditional Formatting Formulas: Cell References To “Jump” To Next Template

Download File: https://excelisfun.net/files/EMT1448.xlsx Entire page with all

Excel Magic Trick 167p1 IF function formula: 12 Examples!

Excel Magic Trick 167p1 IF function formula: 12 Examples!

Excel If statement

Excel Magic Trick 1145: Create Random Data Set with Formulas: 4 Unusual Formulas

Excel Magic Trick 1145: Create Random Data Set with Formulas: 4 Unusual Formulas

Download

Excel Magic Trick 1149: Dynamically Sum by Category without VLOOKUP Helper Column (2 methods)

Excel Magic Trick 1149: Dynamically Sum by Category without VLOOKUP Helper Column (2 methods)

Download

Excel Magic Trick 1097: AND & OR Criteria Together for Counting, Adding, Conditional Formatting

Excel Magic Trick 1097: AND & OR Criteria Together for Counting, Adding, Conditional Formatting

Download

Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTable

Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTable

Download

Excel Magic Trick 1087: OR & IF Function & Conditional Format: Number Outside Lower & Upper Hurdle

Excel Magic Trick 1087: OR & IF Function & Conditional Format: Number Outside Lower & Upper Hurdle

Download

Related Video Content

Office 365 login information

Collaborate for free with online versions of Microsoft Word, PowerPoint, Excel, and OneNote. Save documents,...

Microsoft Excel - Download information

Feb 16, 2026 · Microsoft Excel is built for organizing data, running calculations, and turning tables into decisions....

Microsoft Excel: Spreadsheets - Apps on Google Play information

Spreadsheets & Calculations • Create charts, budgets, project plans, accounting & financial analysis with Excel's...

Microsoft Excel - App Store information

Download Microsoft Excel by Microsoft Corporation on the App Store. See screenshots, ratings and reviews, user tips,...

Download Microsoft Excel for Windows, macOS, Android, APK information

1 day ago · Microsoft Excel is a spreadsheet program from Microsoft and one of the core applications in the Microsoft...