How To Find The Last Non-zero Number In A Column In Excel

Here is an array formula you can use to find the last non-zero entry in a column. We will use the IF and LOOKUP function in the process.

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

What can you do next?
Share this post with others that can benefit from it!
Leave a comment or reply below – let me know what you think!
Subscribe to this blog for more great tips in the future!
Check out my YouTube channel – click on the YouTube icon below!

Happy Excelling!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

3 Responses to How To Find The Last Non-zero Number In A Column In Excel

  1. MAJ May 22, 2015 at 5:41 pm #

    Nice use of lookup, Michael.

    Need to know more on:
    1. How the formula is getting copied in next column when u execute the formula for balance, past purchase etc.
    2. Can we have more info on use of lookup formula?

    • Michael Rempel May 25, 2015 at 1:44 pm #

      MAJ, to copy the formulas, all I did was use the keyboard shortcut Ctrl + C, then to paste it, I used Ctrl + V.
      I will do a post soon on the use of LOOKUP.

      • MAJ May 26, 2015 at 2:31 am #

        Thanks Michael
        By copy, i meant copy of ‘formula text’ only copied in next column, i.e. Formula value is entered in column C, and formula text is getting copied in column D simultaneously.
        How does it work?

Leave a Reply