I have tried searching for the answer to this question but the search engine ignores "last" and "row" as being too common or too short!
I need a formula in my Analysis worksheet that will reference column G in the Sales worksheet and return the value from the last cell in the column that contains data. Sales worksheet contains a list of product sales with a total row at the bottom. The row number for the total will change depending on the number of products sold in a given month. (Sample attached.)
Thanks in anticipation!
Bookmarks