Formula to capture last value within a column

Bruce Case

Hi Community. I need a formula that will capture the value in a cell, from the last populated row in a sheet. Of course, the last row could be row 20, 200, 2000, thus the reason I can't point straight to it. Thoughts?

Andrée Starå

Hi @Bruce Case

I hope you're well and safe!

Try something like this.

=MAX(Column:Column)

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Bruce Case

Here's what I tried: =MAX(Owner:Owner)

If I have my formula column set to text, your formula returns 0. If I set it to a Contact List, as is my Owner column, then I get an error says a Contact is expected.

Andrée Starå

@Bruce Case

Try something like this instead.

=INDEX(Owner:Owner, MATCH(MAX(Created:Created), Created:Created))

Created is the Created Date system column.

Did that work?