Search code examples
google-sheets-formula

LAST COLUMN VALUE IN GOOGLE SHEETS

first time on here.

I need to create a formula that will always return the last payment date each of my clients has made (lowest row). I tried using Index and vlookup but wasn't able to figure it out. It's important for me to keep the table tidy and not fill it with zeroes for the count functions to work.

Example here: https://docs.google.com/spreadsheets/d/1APpxJ3xoTjV1VrXKnaUyFoy5HpuqLo0U4UqfXdQLZRE/edit?usp=sharing

https://i.sstatic.net/9sprw.png

Solution

  • in B31

    =arrayformula(query(sort({row($A3:$A31),{$A3:$A30;0},{B3:B30;""}},1,0),"select Col2 where Col3 is not null limit 1"))

    then drag to right