Top 10 List on the basis of Year and Month

[Nisha Dhawan]

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

[bmouse]

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.

[rabbita]

Hello,

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

Regards,
Alex

[kvsrinivasamurthy]

Pl see file wth formulas.
For B5

Please Login or Register  to view this content.

For C5

Please Login or Register  to view this content.

then drag down.

[samba_ravi]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Vikas_Gautam]

Here is the pivot table approach..
May be exactly what you wanted.
I have made the ranges flexible, so if you add data in sheet1, you will just need to refresh the Pivot table to get the desired results.
Check the attached file:-

[Nisha Dhawan]

Hi Kvsrinivasamurthy,

Its working, thanks for the help