last value in a row

  • Thread starter Thread starter Cees Bruin
  • Start date Start date
C

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
 
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 **
 
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
Click to expand...

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
 
Back
Top