How To Return The First / Last Non Blank Cell In A Row Or Column

How To Return The First / Last Non Blank Cell In A Row Or Column

The following will help to understand the steps on how to return the first / last non blank cell in a row or column

If you are in a rush and want your problem answered, email to exploresarcs@gmail.com or live chat with us.

First Non Blank cell:

=INDEX(A1:A100,MATCH(TRUE,INDEX((A1:A100<>0),0),0))

Last Non Blank cell:

=LOOKUP(2,1/(A1:A100<>””),A1:A100)

www.extendoffice.com/documents/excel/2104-excel-return-first-last-non-blank-cell-in-row-column.html

 

About the author: admin

You must be logged in to post a comment.