Last cell in row range with a result

  • Thread starter Thread starter George
  • Start date Start date
G

George

I need to see if anyone can tell me if it's possible to find the last
cell in a range that has a result and not just a formulas. We have this
file that has a row of formulas as each cell it a different day of the
month. In another file I need to pull the current cell and at this time
I have to change the cell reference. Please let me know, thanks
 
if you have a row of data , say row 3, with no included blanks, then the last
value in that row is:

=INDEX($3:$3,COUNTA($3:$3))
 
Gary''s Student said:
if you have a row of data , say row 3, with no included blanks, then the last
value in that row is:

=INDEX($3:$3,COUNTA($3:$3))
Click to expand...
How are formulas that have no results treated.
 
That cell will be reported if it is the last cell in a row. For example if
the last cell in a row contains:

=INDEX($3:$3,COUNTA($3:$3))

then a blank will be reported.
 
Gary''s Student said:
That cell will be reported if it is the last cell in a row. For example if
the last cell in a row contains:

=INDEX($3:$3,COUNTA($3:$3))

then a blank will be reported.
Click to expand...
Thanks
 
Back
Top