Find last value added in a row
I'm creating a helper column to always capture the latest value in a row. So far the closest I've gotten is to use JOIN and COLLECT to display all not blank cells. I would love to just show the last cell with data, in this case "Balance at Aug close" so that I can use this column for my dashboard and not have to updated the column every month. I have account information on the left and months across the top. Any ideas are greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!