PLEASE HELP! How to display the last cell used in a column?
I'm hoping someone can help me with a problem i'm having. Basically i have a table, at the top is a summary, within that, cell D6, all i want it to do is display a value, the value i want it to display is from a range of cells (D11:D49). D11 has a value in it (the rest are empty) and every week another value will be added below the last, D12, D13 etc. So all i need is for the cell D6 to display the latest entry (which is the cell lowest down) in the column of cells.
I thought this would be a simple thing to do but i cant work out how to do it. I have done some searches online but they come back with info about macros and the like which make no sense to me, i thought there would be a simple way to do this, please help!
for last numeric entry in a column
for last text entry in a column
Thank you, that did the trick!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1