Find last entry in a row

  • Thread starter Thread starter TUF
  • Start date Start date
T

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
 
Are there any 0s in the range? Will the numbers always be positive numbers?
 
Sorry I forgot to mention that there may be negative numbers infrequently.

Cheers
 
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.
 
Thanks,

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

Thanks again
 
It's a different technique:

=IF(COUNT(A1:R1),INDEX(A1:R1,MATCH(TRUE,INDEX(A1:R1<>"",0),0)),"")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Average last 4 entries in a row. 8
Find last row with data 3
Determine cell address of last entry in a row 2
Summary Worksheet. 1
Finding a sum by matching two cells with the same identifier 1
Find the position of a date 6
Search Columns for a word and stop 14

Back
Top