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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variable Range Copy... 13
Macro that copies values from column A (from formula) to B (paste value) 1
How to Past cells with formulas not using "$" without changing ref 3
CF on Consecutive cells 1
Count cells in range 3
Can I reference the currently selected cell in a formula? 4
automatic range in a graph 1
use of Randbetween() in Excel 1

Back
Top