How to find the Average of bottom 10 cells in excel

AvinashY

New Member
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
 

Umuruk

New Member
I didnt have enough time to doing that task but steps in the screenshot will be helpful for your issue
 

Attachments

  • helping6.JPG
    55.1 KB · Views: 55
  • helpingJPG.JPG
    13.8 KB · Views: 36

Sukesh Kumaru

Active Member
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