| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formular to read the last entry in a column
I am trying to calculate a "latest result" in which I need to read the last
(Not greatest or smallest) figure in a column: e.g. column H has five figures in it, 100, 75, 70, 50, 65. I want a cell that will show me the answer or 65, and if another figure is added afterwards, for my latest result cell to show whatever is in this figure. How can I do this??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formular to read the last entry in a column
=LOOKUP(99^99,H:H)
"Dhew" wrote: I am trying to calculate a "latest result" in which I need to read the last (Not greatest or smallest) figure in a column: e.g. column H has five figures in it, 100, 75, 70, 50, 65. I want a cell that will show me the answer or 65, and if another figure is added afterwards, for my latest result cell to show whatever is in this figure. How can I do this??? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formular to read the last entry in a column
Brilliant! I can use this formula, too...
I tried to convert it for rows, but did not suceed. Is there an answer for this? -- Felix "Toppers" wrote: =LOOKUP(99^99,H:H) "Dhew" wrote: I am trying to calculate a "latest result" in which I need to read the last (Not greatest or smallest) figure in a column: e.g. column H has five figures in it, 100, 75, 70, 50, 65. I want a cell that will show me the answer or 65, and if another figure is added afterwards, for my latest result cell to show whatever is in this figure. How can I do this??? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formular to read the last entry in a column
For a good general discussion of the last value, see:
http://www.xldynamic.com/source/xld.LastValue.html -- Gary''s Student - gsnu200734 "Felix" wrote: Brilliant! I can use this formula, too... I tried to convert it for rows, but did not suceed. Is there an answer for this? -- Felix "Toppers" wrote: =LOOKUP(99^99,H:H) "Dhew" wrote: I am trying to calculate a "latest result" in which I need to read the last (Not greatest or smallest) figure in a column: e.g. column H has five figures in it, 100, 75, 70, 50, 65. I want a cell that will show me the answer or 65, and if another figure is added afterwards, for my latest result cell to show whatever is in this figure. How can I do this??? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formular to read the last entry in a column
=Lookup(99^99,1:1)
will return last value in row 1 "Felix" wrote: Brilliant! I can use this formula, too... I tried to convert it for rows, but did not suceed. Is there an answer for this? -- Felix "Toppers" wrote: =LOOKUP(99^99,H:H) "Dhew" wrote: I am trying to calculate a "latest result" in which I need to read the last (Not greatest or smallest) figure in a column: e.g. column H has five figures in it, 100, 75, 70, 50, 65. I want a cell that will show me the answer or 65, and if another figure is added afterwards, for my latest result cell to show whatever is in this figure. How can I do this??? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formular to read the last entry in a column
Excellent thank you, but is there any way to make it so that it doesnt
include 0.00's "Toppers" wrote: =Lookup(99^99,1:1) will return last value in row 1 "Felix" wrote: Brilliant! I can use this formula, too... I tried to convert it for rows, but did not suceed. Is there an answer for this? -- Felix "Toppers" wrote: =LOOKUP(99^99,H:H) "Dhew" wrote: I am trying to calculate a "latest result" in which I need to read the last (Not greatest or smallest) figure in a column: e.g. column H has five figures in it, 100, 75, 70, 50, 65. I want a cell that will show me the answer or 65, and if another figure is added afterwards, for my latest result cell to show whatever is in this figure. How can I do this??? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formular to read the last entry in a column
try:
=INDEX(A:A,MAX(IF(A1:A65535<0,ROW(A1:A65535)))) Enter with Ctrl+Shift+Enter "Dhew" wrote: Excellent thank you, but is there any way to make it so that it doesnt include 0.00's "Toppers" wrote: =Lookup(99^99,1:1) will return last value in row 1 "Felix" wrote: Brilliant! I can use this formula, too... I tried to convert it for rows, but did not suceed. Is there an answer for this? -- Felix "Toppers" wrote: =LOOKUP(99^99,H:H) "Dhew" wrote: I am trying to calculate a "latest result" in which I need to read the last (Not greatest or smallest) figure in a column: e.g. column H has five figures in it, 100, 75, 70, 50, 65. I want a cell that will show me the answer or 65, and if another figure is added afterwards, for my latest result cell to show whatever is in this figure. How can I do this??? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formular to read the last entry in a column
EXCELLENT. Thank you worked like a dream...
VERY MANY THANKS... "Toppers" wrote: try: =INDEX(A:A,MAX(IF(A1:A65535<0,ROW(A1:A65535)))) Enter with Ctrl+Shift+Enter "Dhew" wrote: Excellent thank you, but is there any way to make it so that it doesnt include 0.00's "Toppers" wrote: =Lookup(99^99,1:1) will return last value in row 1 "Felix" wrote: Brilliant! I can use this formula, too... I tried to convert it for rows, but did not suceed. Is there an answer for this? -- Felix "Toppers" wrote: =LOOKUP(99^99,H:H) "Dhew" wrote: I am trying to calculate a "latest result" in which I need to read the last (Not greatest or smallest) figure in a column: e.g. column H has five figures in it, 100, 75, 70, 50, 65. I want a cell that will show me the answer or 65, and if another figure is added afterwards, for my latest result cell to show whatever is in this figure. How can I do this??? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formular to read the last entry in a column
Thank-you this was one of the formulas I wanted for my log book of flying
hours. It worked great! "Dhew" wrote: EXCELLENT. Thank you worked like a dream... VERY MANY THANKS... "Toppers" wrote: try: =INDEX(A:A,MAX(IF(A1:A65535<0,ROW(A1:A65535)))) Enter with Ctrl+Shift+Enter "Dhew" wrote: Excellent thank you, but is there any way to make it so that it doesnt include 0.00's "Toppers" wrote: =Lookup(99^99,1:1) will return last value in row 1 "Felix" wrote: Brilliant! I can use this formula, too... I tried to convert it for rows, but did not suceed. Is there an answer for this? -- Felix "Toppers" wrote: =LOOKUP(99^99,H:H) "Dhew" wrote: I am trying to calculate a "latest result" in which I need to read the last (Not greatest or smallest) figure in a column: e.g. column H has five figures in it, 100, 75, 70, 50, 65. I want a cell that will show me the answer or 65, and if another figure is added afterwards, for my latest result cell to show whatever is in this figure. How can I do this??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA code to read formular from another cell | Excel Discussion (Misc queries) | |||
| inserting a row into a column that is read on another worksheet | Excel Worksheet Functions | |||
| Transpose row to read to column | Excel Worksheet Functions | |||
| how can i change column to read a.b.c.etc and not 1.2.3. | Excel Discussion (Misc queries) | |||
| Formula to read two column come back with one value? | Excel Worksheet Functions | |||
Linear Mode
