Forum Discussion
Solved
How to bottom and second to bottom automatic send to overview?
I am using a spreadsheet to calculate my electricity consumption and a price every quarter. Once a quarter I have to make a report. I would like it to generate the report automatic. We are sharing t...
Assuming your data is sorted, LARGE() should do the trick . You can change 1 to 2 if you want the second one from bottom.
=LARGE(your range, 1)
My bad. It should be like this. = LARGE(SORT(G11:G40),1)
Thank you for your help 🙂 I still get the same error message, but it is okay.