Excel Forum



Excel Magic Trick 365: Return First Non-Blank (Not An Array Formula)


Amazing non-array formula to returns the cell content from the 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.