Hello,
I have a huge spreadhseet of data that details sites and work orders. I need to list the top 5 worst sites (sites with the mmost work orders). Whats the best way to attack this and what formulas should I use?
I thought using countif to count the occurence of each site number...but since one site can have many work orders I have duplicate data for many sites.
So the main questions:
1. What do I need to do in the source spreadhsheet with the work orders...extra columns to count etc and what formulas do I use to aggregate that data?
2. What formulas or methods do I need to use in summary spreadsheet that will detail the top sites (unique) with the most work orders?
Hope I explained that OK. Im assuming this can probably with a pivot table. If this is your recommendation please explain how to set it up to only show the top 5 sites with the most frequency in the data set. Tried but couldnt get that to show the way id like it....just a newbie with pivots
Thanks for your help
I have a huge spreadhseet of data that details sites and work orders. I need to list the top 5 worst sites (sites with the mmost work orders). Whats the best way to attack this and what formulas should I use?
I thought using countif to count the occurence of each site number...but since one site can have many work orders I have duplicate data for many sites.
So the main questions:
1. What do I need to do in the source spreadhsheet with the work orders...extra columns to count etc and what formulas do I use to aggregate that data?
2. What formulas or methods do I need to use in summary spreadsheet that will detail the top sites (unique) with the most work orders?
Hope I explained that OK. Im assuming this can probably with a pivot table. If this is your recommendation please explain how to set it up to only show the top 5 sites with the most frequency in the data set. Tried but couldnt get that to show the way id like it....just a newbie with pivots
Thanks for your help