How to ref the last cell with data in it in a formula

Post Reply
User avatar
Princy557
Posts: 192
Joined: Wed May 18, 2011 10:32 am

How to ref the last cell with data in it in a formula

Post by Princy557 »

Please see the attached snap.
How do I reference the red and blue cells, the values in B will be added to at no fixed date and time so I can't predict B12 or B15.
In other words, I need to replace B12 or B15 with a formula.
Ashampoo_Snap_Monday, 30 January 2023_19h57m8s.png
Regards

Princy557
User avatar
Princy557
Posts: 192
Joined: Wed May 18, 2011 10:32 am

Re: How to ref the last cell with data in it in a formula

Post by Princy557 »

Ashampoo_Snap_Tuesday, 31 January 2023_20h21m18s.png
This seems to work
Regards

Princy557
Post Reply

Return to “PlanMaker 2021 for Windows”