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.