Formula to pull latest updates from a row

JoelN

I am trying to setup a dashboard that gets updated with KPI's monthly. But, I only want the most recent entry to be reflected in the charts/dashboard. I get the gist of how to do it with if/or/isblank formulas, but can't quite get it right. It's reversed right now, I can fix that. Am I on the right track here, just need to write it all out for Jan-Dec?

=IF(OR(NOT(ISBLANK(January@row)), NOT(ISBLANK(February@row))), January@row, February@row)

Jgorsich

That path will work, but it will be a little cumbersome.

You can use the index() function to somewhat mimic Excel's offset function like this:

=INDEX([January]@row:[December]@row, 1, COUNT([January]@row:[December]@row))

The "1" in the middle is to tell it to not offset rows at all so that you are just indexing along the columns.