•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to find the last filled in value in a range
Hello,
I need a formula where it returns the value of the last filled in cell within a certain range.
For example range A1:A10 where A1,A3 & A8 are filled in with a value.
I would like a formula where he searches in range A1:A10 and it gives me the value of cell A8.
Does anyone know more about INDEX etc. that can help me with this formula?
Thank you very much in advance!
[link] [comments]
Want to read more?
Check out the full article on the original site