General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
28 Apr 10
11:13
Joined:
Date Joined:
28 Oct 08
Sorry!!
But I have a spreadsheet with lots of values and it's getting longer and longer every day but information I'd like to be able to glance at is at the top of the doc. Is there any way to have it floating beside where the next values will be entered and have it trailing the next empty cell?
But I have a spreadsheet with lots of values and it's getting longer and longer every day but information I'd like to be able to glance at is at the top of the doc. Is there any way to have it floating beside where the next values will be entered and have it trailing the next empty cell?
Show More
=OFFSET(A1,COUNTA(A:A)-1,0)
That is if there are no blank cells in column A
Put that formula in a cell at the top somewhere you want to see
the last value in a column, BUT NOT in column A
Change A for the column with the values.
That is if there are no blank cells in column A
Put that formula in a cell at the top somewhere you want to see
the last value in a column, BUT NOT in column A
Change A for the column with the values.
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539