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

Hi Rohit,

See if the attached is what you are looking for.