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 -