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)
It works great for the first two, as the reading up the total consumption only increases. However, the last one is the price and that varies up and down in value.
You can cover LARGE() with SORT() for the last column.
=SORT(LARGE(Your range,1))
It says it is not valid. Even if I just choose from G11 to G40 insted of the Table1.
If it does not work I can live with having to fill one cell manuel, just a bummer when the rest now works so well.
- 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.