I have a column of numerical data, say a1:a20. I want to search that range and return either the cell address of the last non-zero, non-empty cell, or if that can't be done, the row number (since I already know the column). TIA

migrated from superuser.com Nov 8 at 22:17

This question came from our site for computer enthusiasts and power users.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy