CODEWITHSUNDEEP
excel
Vignesh Subramanian
Vignesh Subramanian

Reputation: 7289

Calculating average of distinct column values in excel

I have the following excel sheet 

  C                D                E


Activity1         40%     Sub activity
Activity1         30%     Sub activity
Activity2         20%     Sub activity
Activity2         20%     Sub activity
Activity2         70%     Sub activity
Activity3         30%     Sub activity
Activity3         30%     Sub activity
Activity3         30%     Sub activity

I want to get an output like this

           A             B
      Activity1         35%
      Activity2         30%
      Activity3         30%

I am new to excel please help me on how to get the result like that? which formula can i use to get something like this??

Upvotes: 2

Views: 3002

Answers (1)

PKumar
PKumar

Reputation: 11128

You do something like this:

Select the data , Hit Alt + D + P and three times enter.You got a pivot table in new sheet.

In values take average instead of sum , If the format is not in percentage , Hit CTRL + SHIFT+ 5 , you have the numbers in percentage format now.

enter image description here

enter image description here

I hope this would help

Upvotes: 2

Related Questions