Excel Forum
Similar Content
Formula to Get the Last Value from a List in Excel
Tutorial: Formulas that you can use to get the value of the last non-empty cell in a range in Excel...
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...
HLOOKUP in Excel
Tutorial: The Hlookup function allows you to scan a row from left to right in search of a value and ...
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 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.