The doomed
Active Member
- Joined
- Feb 13, 2008
- Messages
- 263
I have a sheet set up as follows:
Cell I1 = Publication Date (Manually entered - always a Wednesday)
Col.A - Date - the Wednesday of each week for the foreseeable future
Col.F - Number of items
Col.G - Running total of the numbers entered in F
Col.H - Week number (incremental from 1)
Col.I - Average number to date
Col.I rows have the following formula (basically, if no figure in ColF show blank...
=IF(F7>=1,G7/H7,"")
Data entry starts on Row 3.
That all works fine in a nice simple way to give me what I want. However, I want to pull the latest average figure on to another sheet to present in a weekly report.
Can I use the publication date in I1 to determine what row to pull the average from? Or can I do something that will look to the last no-blank cell in Col.I?
Being honest - if there is something simple to look to the last non-blank cell in the colum that would be best going forward but I'm not fussed.
Any help greatly appreciated, as ever.
Cell I1 = Publication Date (Manually entered - always a Wednesday)
Col.A - Date - the Wednesday of each week for the foreseeable future
Col.F - Number of items
Col.G - Running total of the numbers entered in F
Col.H - Week number (incremental from 1)
Col.I - Average number to date
Col.I rows have the following formula (basically, if no figure in ColF show blank...
=IF(F7>=1,G7/H7,"")
Data entry starts on Row 3.
That all works fine in a nice simple way to give me what I want. However, I want to pull the latest average figure on to another sheet to present in a weekly report.
Can I use the publication date in I1 to determine what row to pull the average from? Or can I do something that will look to the last no-blank cell in Col.I?
Being honest - if there is something simple to look to the last non-blank cell in the colum that would be best going forward but I'm not fussed.
Any help greatly appreciated, as ever.