Excel Forum
Similar Content
Formula to Get Value of Last Non-Empty Cell in Excel
Tutorial: Formulas that you can use to get the value of the last non-empty cell in a range in Excel....
Find the Most Frequently Occurring Value in a List in Excel
Tutorial: Use a formula to return the most frequently occurring word or value from a range of cells...
Multiply by True and False in Excel
Tutorial: You can multiply numbers by TRUE and FALSE in Excel. This effectively allows you to elimi...

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.