Excel Forum
Similar Content
Count Blank Cells in Excel
Tutorial: How to count blank cells, including formulas that output a blank. Sections: Count Blank C...
HLOOKUP in Excel
Tutorial: The Hlookup function allows you to scan a row from left to right in search of a value and ...
Create Gantt Chart in Excel Easily
Tutorial: Easy step-by-step guide to creating a Gantt Chart in Excel. Following these steps, it sh...

Excel Magic Trick 363: Return Cell Address of First Non-Blank

Array Formula for returning cell address for first non-blank cell that uses the functions: ADDRESS, MIN, IF, COLUMN, ROW and the not comparative operator and the symbol for blank (double quotes). Formula from Aladin from Mr Excel Message Board.

Got a Question? Ask it Here in the Forum.