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 - gsnu200713

Gary''s Student wrote:
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))


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 - gsnu200713


"George" wrote:

Gary''s Student wrote:
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))


How are formulas that have no results treated.

You might also try:
=LOOKUP(2,1/($3:$3<""),$3:$3)

"George" wrote:

Gary''s Student wrote:
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))


How are formulas that have no results treated.

Gary''s Student wrote:
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.
Thanks

JMB wrote:
You might also try:
=LOOKUP(2,1/($3:$3<""),$3:$3)

"George" wrote:

Gary''s Student wrote:
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))


How are formulas that have no results treated.

Thanks