I was recently asked by a friend to help her identify who were the top three contributors in a project – based on Page Views and Participation. She also wanted to get some idea of frequency of contribution..

You can download  the original (anonymised) file here.    

Part One – Setting up the data and identifying the Top Three


Part Two – Getting frequency percentages.

In this video I show you how to use data bars to help flag up the higher numbers and also how to use a pivot table to automatically calculate the percentages.

You can download the completed file here