Last Populated Cell in Column

Paul McQuiston

Hello everyone,

Hopefully an easy one!

I have a set of eight fixed rows on SS. I have built out colums representing the fiscal weeks . . (ie) 2021-01, 2021-02, 2021,03 ect. Each week I add a number, or text, in the revelent column.

I'm trying to find a formula to reference the last figure to the right. I'll then pull that to a dashboard.

Thanks!

Paul

Mark Cronk

Hi @Paul McQuiston ,

There is probably an easier way but this should work:

=IF(ISBLANK([2021-02]@row, [2021-01]@row, IF(ISBLANK([2021-03]@row, [2021-02]@row, IF(ISBLANK([2021-04]@row, [2021-03]@row, IF(ISBLANK([2021-05]@row, [2021-04]@row, IF(ISBLANK([2021-06]@row, [2021-05]@row, IF(ISBLANK([2021-07]@row, [2021-06]@row, IF(ISBLANK([2021-08]@row, [2021-07]@row, IF(ISBLANK([2021-09]@row, [2021-08]@row, IF(ISBLANK([2021-10]@row, [2021-09]@row, IF(ISBLANK([2021-11]@row, [2021-10]@row, IF(ISBLANK([2021-12]@row, [2021-11]@row, [2021-12]@row)))))))))))

Mark