Hello, I don't know how to explain this but I will try.
Week------Sales
1-----------500
2-----------600
3-----------300
4----------Div/0
5----------Div/0
First Week 500
Last Week (Formula)
So basically I want it to know what is last data is. It's 300, but I want excel automatically to put the number in. Is there a formula for this like =line(b1:b4),1) or something like that?
Thanks, Bogdan.
http://www.excelforum.com/attachment...1&d=1468256035
Bookmarks