Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create a formula in Excel that finds the value of the la.
I am needing assitance in finding a formula that allows me to find the value
of the last nonblank cell in a range. |
#2
|
|||
|
|||
=INDEX(A1:A10,MATCH(FALSE,ISBLANK(A1:A10),0))
array entered (ctrl+shift+enter) However if your values are always number then this should do =LOOKUP(999999999999999,A:A) assuming the looked up value is in column A "BerlinUSA" wrote in message ... I am needing assitance in finding a formula that allows me to find the value of the last nonblank cell in a range. |
#3
|
|||
|
|||
Take a look at http://www.xldynamic.com/source/xld.LastValue.html
-- HTH RP (remove nothere from the email address if mailing direct) "BerlinUSA" wrote in message ... I am needing assitance in finding a formula that allows me to find the value of the last nonblank cell in a range. |
#4
|
|||
|
|||
On Fri, 15 Apr 2005 13:36:04 -0700, BerlinUSA
wrote: I am needing assitance in finding a formula that allows me to find the value of the last nonblank cell in a range. =LOOKUP(2,1/(1-ISBLANK(rng)),rng) Note that "rng" cannot be more than 65,535 cells (so a full column reference like A:A will not work). If it might be, post back for another solution. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Create an if-then formula in Excel to limit column total? | Excel Discussion (Misc queries) | |||
Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel | |||
How to I use ** without Excel thinking I want to type a formula? | Excel Discussion (Misc queries) | |||
How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions |