Excel Forum



Excel Magic Trick 364: Return First Non-Blank (Array Formula)


Array formula for returning cell content from first non-blank cell in a row that uses INDEX, MATCH 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.