Using Excel version 7. Can anyone provide simply method of copy last nonzero entry in a column range to another cell? Column is calculating a variance between actual and budgeted sales; since entire year is budgeted, and entries are made to actuals as weeks end, I need to report YTD variance in my totals line a bottom of spreadsheet. Help please!
