Software

Ask something
Discussion Locked

last nonzero entry in Excel column

0 helpful
3 replies

by jrh2809

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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!

3 replies

by parier

Say you last total is on A15, you want it up over to B2. THen click on B2 cell and type
=(A15)

If any numbers from A1 thru A14 change and then that will make the total in A15 change, then B2 total will change to follow.

Hope this helps, if not, reply with a return phone number and I can call to help.

Eric

This discussion is closed to new replies.