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.
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.