How do I extract lateat entry in a series of data

Hi

I need to insert the "latest" entry of a column (the one furtest down in the a Column) in a formula. Is there anyway to do that?

As in =("highest cellnumber in B that has an entry")/((E7-A2)/100)

Thanks in advance