Excel Forum



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.