last value in a row

[Cees Bruin]

there probably is a fuction which will give me the last
value in a row, the thing is I dont know which one, i use
the max value .. but there could be a problem when numbers
are decreasing it will still give me the (then uncorrect)
high figure in stead off the last figure.

your help is much appriciated
best regards

Cees

 

[Paul B]

Cees, try this it will return the last numeric valve in row 1
=INDEX(1:1,MATCH(9.9999999999E+307,1:1))
--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Ron Rosenfeld]

there probably is a fuction which will give me the last
value in a row, the thing is I dont know which one, i use
the max value .. but there could be a problem when numbers
are decreasing it will still give me the (then uncorrect)
high figure in stead off the last figure.

your help is much appriciated
best regards

Cees

For row 18, the *array-entered* formula:

=INDEX(18:18,1,MAX(ISNUMBER(18:18)*COLUMN(18:18)))

To *array-enter* a formula, after typing or pasting it into the cell, hold down
<ctrl><shift> while hitting <enter>. XL will place braces {...} around the
formula.


--ron