Excel Forum
Similar Content
Formula to Get Value of Last Non-Empty Cell in Excel
Tutorial: Formulas that you can use to get the value of the last non-empty cell in a range in Excel....
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 ...



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.