View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andre C Andre C is offline
external usenet poster
 
Posts: 1
Default Extract Top 5 value from a pivot table

Hello,

I have a a pivot table listing by country and months of the number of times
a certain internet page has been reviewed.

I would like to have a formula (x5) which would extract the 5 highest pages
viewed for a given month and given country.

I tried the Getpivotdata and sumproduct functions, but I am getting nowhere.

Can you help?

Thank you