Find last value in column...
 

In column J from J2:J46 I have percentages and tomorrow I will add another
percentage which will go in J47 and this will continue everyday. I would
like a formula in cell J84 to find the last cell that has a percentage and
have that percentage show up in cell J84. So today it would grab the
percentage from cell J46 and tomorrow it would grab the percentage from cell
J47. Thanks.

Find last value in column...
 

Try this:

=LOOKUP(1000,J2:J83)

It will find the last number entered in the range J2:J83 which is less
than 1000. Format the cell as percentage if that is how you want it
displayed.

Hope this helps.

Pete

On Jan 16, 3:51*pm, Jambruins
wrote:
In column J from J2:J46 I have percentages and tomorrow I will add another
percentage which will go in J47 and this will continue everyday. *I would
like a formula in cell J84 to find the last cell that has a percentage and
have that percentage show up in cell J84. *So today it would grab the
percentage from cell J46 and tomorrow it would grab the percentage from cell
J47. *Thanks.

Find last value in column...
 

thanks, that works perfectly.

"Pete_UK" wrote:

Try this:

=LOOKUP(1000,J2:J83)

It will find the last number entered in the range J2:J83 which is less
than 1000. Format the cell as percentage if that is how you want it
displayed.

Hope this helps.

Pete

On Jan 16, 3:51 pm, Jambruins
wrote:
In column J from J2:J46 I have percentages and tomorrow I will add another
percentage which will go in J47 and this will continue everyday. I would
like a formula in cell J84 to find the last cell that has a percentage and
have that percentage show up in cell J84. So today it would grab the
percentage from cell J46 and tomorrow it would grab the percentage from cell
J47. Thanks.

Find last value in column...
 

Glad to hear it - thanks for feeding back.

Pete

On Jan 16, 4:10*pm, Jambruins
wrote:
thanks, that works perfectly.



"Pete_UK" wrote:
Try this:

=LOOKUP(1000,J2:J83)

It will find the last number entered in the range J2:J83 which is less
than 1000. Format the cell as percentage if that is how you want it
displayed.

Hope this helps.

Pete

On Jan 16, 3:51 pm, Jambruins
wrote:
In column J from J2:J46 I have percentages and tomorrow I will add another
percentage which will go in J47 and this will continue everyday. *I would
like a formula in cell J84 to find the last cell that has a percentage and
have that percentage show up in cell J84. *So today it would grab the
percentage from cell J46 and tomorrow it would grab the percentage from cell
J47. *Thanks.- Hide quoted text -

- Show quoted text -