Please Help

D

diaz377

How can I output the last value entered in a range of cells into anothe
cell?
Example (Range= A1:A100, last value entered in A50)
I want the value from A50 to be uotputed into B1
Thank
 
F

Frank Kabel

Hi
if you have no blanks rows in between in column A enter the following
in B1:
=OFFSET($A$1,COUNTA(A1:A100)-1,0)

Frank
 
Top