Top 10 List on the basis of Year and Month

Hi All,

I have a website data of 2 years, in which I want to return Top 10 link's list on the basis of Year and Month. The top ten links will be based on search volume.

In sheet 2 I want if I select year and month then I will get top ten links with search volume.


Thanks in advance
Nisha

You can achieve the same results by using auto-filters on your data in Sheet 1. Sort all data based on Search Volume, then select to show only the data for a certain year/month and the first 10 entries are your results. I will try to work on the exact solution you requested some more.

Hello,

Have you thought about a pivot table? Or is it necessary for you to use Excel functions?

Regards,
Alex

Pl see file wth formulas.
For B5

=IFERROR(INDEX(Sheet1!$C$2:$C$28,SMALL(IF((Sheet1!$A$2:$A$28=Sheet2!$C$2)*(Sheet1!$B$2:$B$28=Sheet2!$D$2)*(Sheet1!$L$2:$L$28=Sheet2!C5),ROW($A$2:$A$28),""),COUNTIF($C3:$C5,C5))-ROW($A$2)+1),"")

For C5

=IFERROR(LARGE(IF((Sheet1!$A$2:$A$28=Sheet2!$C$2)*(Sheet1!$B$2:$B$28=Sheet2!$D$2),Sheet1!$L$2:$L$28,""),ROW(A1)),"")

then drag down.

Hi Kvsrinivasamurthy,

Its working, thanks for the help