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.