Forum Discussion
SarahH1021
Feb 10, 2024Copper Contributor
How to match a cell with the latest filled in cell in a specific colunn
I would like cell D1 to match the information from the last filled out cell in column C which is currently cell C19. Since I am constantly adding new new rows the information in D1 needs to ...
djclements
Feb 11, 2024Silver Contributor
SarahH1021 Since column C appears to be a running total for the values in column B, you could simply SUM column B. For example:
=SUM(B3:B10000)SarahH1021
Feb 11, 2024Copper Contributor
This can work too - thank you!