# I want to know average of top 10 values in H column based on Column C, Column D.

1. ## I want to know average of top 10 values in H column based on Column C, Column D.

Guys I need help on this

Please find my attached sheet.
I want to know average of top 10 values in H column based on Column C, Column D.

I have referred excel sheet PT AVERAGE LARGE 10, and trying to build values in my sheet but i am making mistake somewhere.

Regards,
Rohit

2. ## Re: I want to know average of top 10 values in H column based on Column C, Column D.

hi Rohit. but there's no "Home Page" in "Dump" sheet. you can try this array formula in H2:
=AVERAGE(LARGE(IF(Dump!C2:C89=A2,IF(Dump!D2:D89=B2,Dump!H2:H89)),ROW(INDIRECT("1:10"))))
...confirmed by pressing CTRL-SHIFT-ENTER to activate the array. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL-SHIFT-ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

i used "Shopping" as an eg. the answer is 8.66%. if i got it wrong, do let us know what is supposed to be the right answer & how do you get that

3. ## Re: I want to know average of top 10 values in H column based on Column C, Column D.

Hi Rohit,

See if the attached is what you are looking for.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1