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!