Show last total figure
 

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
--

--
please can you help... its urgent

Show last total figure
 

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" wrote:

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
--

--
please can you help... its urgent

Show last total figure
 

not helping it gives me the following answer #VALUE!

Anything we might have missed out?
--
please can you help... its urgent


"Mike H" wrote:

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" wrote:

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
--

--
please can you help... its urgent

Show last total figure
 

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

"Moh" wrote:

not helping it gives me the following answer #VALUE!

Anything we might have missed out?
--
please can you help... its urgent


"Mike H" wrote:

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" wrote:

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
--

--
please can you help... its urgent

Show last total figure
 

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.

"Mike H" wrote:

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

"Moh" wrote:

not helping it gives me the following answer #VALUE!

Anything we might have missed out?
--
please can you help... its urgent


"Mike H" wrote:

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" wrote:

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
--

--
please can you help... its urgent

Show last total figure
 

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?
--
please can you help... its urgent


"Mike H" wrote:

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

"Moh" wrote:

not helping it gives me the following answer #VALUE!

Anything we might have missed out?
--
please can you help... its urgent


"Mike H" wrote:

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" wrote:

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
--

--
please can you help... its urgent

Show last total figure
 

=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" wrote in message
...
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
--

--
please can you help... its urgent

Show last total figure
 

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


"Bob Phillips" wrote:

=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" wrote in message
...
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
--

--
please can you help... its urgent