Find last entry in a row

[TUF]

HI,

I have rows of figures under monthly categories, i.e. Jan, Feb, Mar etc. . ,
there are empty cells within each row (approx 18 columns wide).

What I am trying to get is a formula that reads the last entry in the row
even if there are empty cells on either side of it

Thanks

 

[T. Valko]

Are there any 0s in the range? Will the numbers always be positive numbers?

 

[TUF]

There are no 0s but there are blank cells

Cheers

 

[TUF]

Sorry I forgot to mention that there may be negative numbers infrequently.

Cheers

 

[T. Valko]

Try this:

=IF(COUNT(A1:R1),LOOKUP(1E100,A1:R1),"")

It'll return the rightmost number in the range. If no numbers are present
it'll return a blank.

 

[TUF]

Thanks,

That's seems to have done the trick. Out of curiosity is there a left most
version?

Thanks again

 

[T. Valko]

It's a different technique:

=IF(COUNT(A1:R1),INDEX(A1:R1,MATCH(TRUE,INDEX(A1:R1<>"",0),0)),"")

 

[TUF]

Once again, thanks

It's a different technique:

=IF(COUNT(A1:R1),INDEX(A1:R1,MATCH(TRUE,INDEX(A1:R1<>"",0),0)),"")

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Once again, thanks