Forum Discussion
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 be updated. I want that to automatically match the latest info added to column C. Is there a function that can do that automatically?
I am constantly adding new new rows the information I'd suggest you work with a Table (benefits of using Tables😞
- I will definitely look into using tables - this seems to be really easy and convenient. Thank you!
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)- This can work too - thank you!
Thank you - this worked!
