» Find the value in the first non blank cell in range in Microsoft Excel
CATEGORY - Other Q&A Formulas
VERSION - All Microsoft Excel Versions
Text/Numeric data in column A
A1
A2 AAA
A3
A4 BBB
A5 CCC
A6 DDD
A7 502
A8 EEE
A9
A10
Formula in cell B1: {=INDEX(A1:A10,MATCH(TRUE,LEN(A1:A10)<>0,0),1)}
Result: AAA
Please note: The formula is an Array Formula, after entering the formula in the cell, press F2 and than press Ctrl+Shift+Enter

Book Store:
Recommended Books:
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Mastering Excel 2000 (for beginner)
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
No comments have been submitted.

