This was very helpful to me, but I also need it to look up the one to the
left of that particular column... I am trying to create a formula that will
take the last column with a non-zero entry and subtract from it the entry
from the previous column without specifying names so that it can work over a
52-column spread sheet. I am updating the sheet every week and want the
current charges column to equal the last entry (cumulative charge) minus what
the cumulative charge was the week before. I don't know if that makes sense
or not.

"Pete_UK" wrote:

If headings are in row 1 and data starts in A2, put this in E2:

=LOOKUP(10^100,A2:D2)

Will return the last non-zero entry in the range.

Hope this helps.

Pete

On Feb 13, 1:39 am, sue wrote:
week1 week2 week3 week4 total
1500 3000 3000
the total column picks up the last column other than zero



"Tyro" wrote:
Well, first of all, no caps, please. It is considered yelling. Secondly give
us an example of your data and what you want to see as a result. We are not
deaf mind readers.

Tyro

"sue" wrote in message
...
I have week1 week2 week3 week4 total
I want a formula and/or function to pick up the last week populated with a
higher amount than null/zero into the total field- Hide quoted text -

- Show quoted text -