How to find the Average of bottom 10 cells in excel

#1
Hi,

I have an excel with 3 columns and i want to find the average of 10 rows from bottom only from column c.

Ex: How the column c looks from bottom

1
2
3
4
5
6
7
8
9
10
11
12
13
14

i want to find the average from bottom (14 to 5).

Thanks
 
#3
Hello,

For this scenario,
First find the last cell Example: C20,(it is the bottom right last cell in excel file)
based on this value C20, try to loop the values from C20-C10 and within that loop use variable to operation and put those values in List variable and perform average operation.

NB: C20 is cell index and decrease the C20 to C10 by making it dynamic, i.e. if other file it is C50, then it should loop from C50-C40 likewise move on.

Good Luck.
 
Top