| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i calculate 20% of a total figure | Excel Worksheet Functions | |||
| HOW DO I COPY A TOTAL FIGURE FROM 1 SHEET TO NEXT ADDING RUNNING T | Excel Worksheet Functions | |||
| How do I figure out a pre-tax amount when I know the final total? | Excel Worksheet Functions | |||
| HOW DO WE SET A FORMULA TO FIGURE A YEAR TO DATE TOTAL ?? | Excel Worksheet Functions | |||
| HOW DO WE SET A FORMULA TO FIGURE A YEAR TO DATE TOTAL ?? | Excel Worksheet Functions | |||
Linear Mode
