Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell is "Last value" in range
Hi,
I have a question about getting the last value of a range en put this value into another cell. Is that possible? Kind regards, Stefan van der Hooft |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell is "Last value" in range
Stefan, numeric valve? Try this, =LOOKUP(9.99999999999999E+307,A:A)
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Stefan van der Hooft" wrote in message ... Hi, I have a question about getting the last value of a range en put this value into another cell. Is that possible? Kind regards, Stefan van der Hooft |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell is "Last value" in range
Put this formula in the other cell:
=INDEX(B:B,MATCH(10^10,B:B)) Uses Index and match for a number larger than any number in your range... will return last number. If you have anything bigger than ten to the tenth, adjust accordingly. :-) Can also be used with entire column, if desired: =INDEX(B:B,MATCH(10^10,B:B)) "Stefan van der Hooft" wrote: Hi, I have a question about getting the last value of a range en put this value into another cell. Is that possible? Kind regards, Stefan van der Hooft |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |