Excel Forum
Similar Content
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Ma...
Count Blank Cells in Excel
Tutorial: How to count blank cells, including formulas that output a blank. Sections: Count Blank C...
Ignore Blanks in a Data Validation List in Excel
Tutorial: I will show you 3 ways to remove the blanks from a Data Validation dropdown menu in Excel...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 532: Count Blanks In Dynamic Range INDEX MATCH COUNTBLANK functions


See how to count blanks in a dynamic range using COUNTIF, INDEX, MATCH, COUNTA and OFFSET. Learn about the difference between an empty cell and a blank. See how to create dynamic ranges with INDEX and OFFSET (Index:Index). Learn about MATCH function using a 2 as the lookup value. Amazing use of INDEX to trick COUNTIF into not seeing an array! Domenic at Mr Excel Message Board xl-central.com xl-central xl-central[dot]com





Got a Question? Ask it Here in the Forum.