last value in a row

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

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 **
"Cees Bruin" wrote in message
...
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

On Wed, 17 Sep 2003 02:44:33 -0700, "Cees Bruin"
wrote:

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
ctrlshift while hitting enter. XL will place braces {...} around the
formula.


--ron

Assuming row 1 with no blank cells between values:

=INDEX(1:1,COUNTA(1:1))

With blank cells between values:

=INDEX(1:1,MAX(IF(1:1"",COLUMN(1:1))))

Second formula is an array, which means you must press
ctrl/shift/enter after inserting the formula.

HTH
Jason
Atlanta, GA

-----Original Message-----
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
.