Forum Discussion
Solved
How to Reference the Last Cell in a Column in a Table?
I have a table where I add data at the end of every day. I would like a formula to reference the last value in a column. Is there an easy way to do that? In the photos above, I would lik...
- Thank you for your reply. I looked at your and JMB17's reply to create me own.
Initially, I mentioned about the count. I did not want to have to manually keep track of the count, but I can use the count function to help me.
I am not sure how to show code, but my formula is as follows:
` =INDEX(KeyTable[KeyThree], COUNT(KeyTable[KeyThree]))
It's really just a hybrid of the two prior ideas.
Thank you for helping me with this small problem.
Hi there,
I hope the following formula will help you to find last cell value in a Column in a Table.
=LOOKUP(3, 1/(KeyTable[KeyOne]<>""),KeyTable[KeyOne])
Just in case, that's what Jeff Blakley suggested in very first answer.
It is very possible.
I just was hurry in answering so that haven't mentioned.
Thank you for your information.