Pick from list

J

Jonbob

Board Regular
Joined
Feb 6, 2003
Messages
160
I have values in column A that I enter every day. 1st day I enter a value in A1, next day A2, etc...

How can I, in cell B1, pick the last value in the list? Not necessarily the highest or lowest value, just the last one?
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Sort by date Sort by votes
Define a dynamic range name, for example 'LastValue' and put the formula =LastValue in B1

Name LastValue defined as
=OFFSET(Sheet1!$A$1,COUNTA(Sheet1!$A:$A)-1,0)

This particular definition assumes there will be continuous values down column A with no blanks inbetween.
 
Upvote 0
You must log in or register to reply here.

Similar threads

I
  • Question
Pick highest numerical version in a List
2
Replies
11
Views
339
indy1982
I
K
  • Question
Get values from one worksheet and place it into another worksheet
Replies
1
Views
246
PeteWright
PeteWright
R
  • Solved
Pick Random From List, Then Delete
Replies
9
Views
407
Peter_SSs
Peter_SSs
S
  • Question
Insert row based on sort
Replies
0
Views
219
ShoYnn
S
P
  • Question
Formulas & functions from price matrix
Replies
3
Views
311
peebee37
P

Forum statistics

Threads
1,203,600
Messages
6,056,200
Members
444,850
Latest member
dancasta7

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top