Find last entry in a row
 

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

Find last entry in a row
 

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

--
Biff
Microsoft Excel MVP


"TUF" wrote in message
...
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

Find last entry in a row
 

There are no 0s but there are blank cells

Cheers

"T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP


"TUF" wrote in message
...
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

Find last entry in a row
 

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

Cheers

"TUF" wrote:

There are no 0s but there are blank cells

Cheers

"T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP


"TUF" wrote in message
...
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

Find last entry in a row
 

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.

--
Biff
Microsoft Excel MVP


"TUF" wrote in message
...
Sorry I forgot to mention that there may be negative numbers infrequently.

Cheers

"TUF" wrote:

There are no 0s but there are blank cells

Cheers

"T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP


"TUF" wrote in message
...
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

Find last entry in a row
 

Thanks,

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

Thanks again

"T. Valko" wrote:

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.

--
Biff
Microsoft Excel MVP


"TUF" wrote in message
...
Sorry I forgot to mention that there may be negative numbers infrequently.

Cheers

"TUF" wrote:

There are no 0s but there are blank cells

Cheers

"T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP


"TUF" wrote in message
...
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

Find last entry in a row
 

It's a different technique:

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

--
Biff
Microsoft Excel MVP


"TUF" wrote in message
...
Thanks,

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

Thanks again

"T. Valko" wrote:

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.

--
Biff
Microsoft Excel MVP


"TUF" wrote in message
...
Sorry I forgot to mention that there may be negative numbers
infrequently.

Cheers

"TUF" wrote:

There are no 0s but there are blank cells

Cheers

"T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP


"TUF" wrote in message
...
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

Find last entry in a row
 

Once again, thanks

"T. Valko" wrote:

It's a different technique:

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

--
Biff
Microsoft Excel MVP


"TUF" wrote in message
...
Thanks,

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

Thanks again

"T. Valko" wrote:

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.

--
Biff
Microsoft Excel MVP


"TUF" wrote in message
...
Sorry I forgot to mention that there may be negative numbers
infrequently.

Cheers

"TUF" wrote:

There are no 0s but there are blank cells

Cheers

"T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP


"TUF" wrote in message
...
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

Find last entry in a row
 

You're welcome!

--
Biff
Microsoft Excel MVP


"TUF" wrote in message
...
Once again, thanks

"T. Valko" wrote:

It's a different technique:

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

--
Biff
Microsoft Excel MVP


"TUF" wrote in message
...
Thanks,

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

Thanks again

"T. Valko" wrote:

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.

--
Biff
Microsoft Excel MVP


"TUF" wrote in message
...
Sorry I forgot to mention that there may be negative numbers
infrequently.

Cheers

"TUF" wrote:

There are no 0s but there are blank cells

Cheers

"T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP


"TUF" wrote in message
...
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