Show last total figure

[Moh]

I have a list in column f, which gives me totals from columns d and e. From
rows 9 to 1095 constantly. This is all good.

But does anyone know how to bring up the last total in column f.
e.g (cell f1096) should give me the last total from f9 to f1095.

column d column e column f
9 5 6 -1
10 6 3 2
11 1 1 2
12 2 1 3
13 6 12 -3
14
...
...
1096

As the last total is in f13, that total should appear in f1096 and when i
enter the next total in f14 that should automatically appear in f1096 instead
of f13.

can anyone help? its just a formula i need to enter in f1096

 

[Mike H]

Try this in F1096

=INDEX($F$1:$F$1095,LARGE(IF($F$1:$F$1095<>"",ROW($F$1:$F$1095)),1),1)

It's an array so enter with Ctrl+Shift+enter

Mike

 

[Moh]

not helping it gives me the following answer #VALUE!

Anything we might have missed out?

 

[Mike H]

It's giving #VALUE! because you haven't entered it as an array formula

Paste the formula into a cell then hit CTRL+Shift+Enter.

Mike

 

[Mike H]

In addition ensure the cursor is in the formula bar when you hit Ctrl+Shift
+Enter and Excel wil add curly brackets {} around the formula. Note you can't
add these brackets manually.

 

[Moh]

DONE THAT MIKE.... STILL SAME PROBLEM...

I NOTICED THAT IT'S ADD THIS { } TO THE FORMULA AFTER HITTING CRTL-SHIFT
AND ENTER

can you please help further?

 

[Bob Phillips]

=LOOKUP(2,1/(F1:F1095<>""),F1:F1095)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Moh]

Bob thank you so much

thank you
thank you


IT WORKED !!!!!!!!!!

it sounds like you know your stuff very well...

Mike thanks for your help too most appreciated.
--
please can you help... its urgent

=LOOKUP(2,1/(F1:F1095<>""),F1:F1095)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)