•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
Tagged with
#AI formula generation techniques
#formula generator
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#last filled value
#formula
#cell
#range
#A1:A10
#value
#filled in
#last value
#INDEX
#Excel
#cell value