Please Help

  • Thread starter Thread starter diaz377
  • Start date Start date
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
 
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
 
Back
Top