 Here is how to use a pivot table to find headcount and an office in fast. I'm on the fast employee data. I'm just going to click into a cell, any cell in the data, go to Insert, Pivot Table. I'm going to let it use the default range. I want a new worksheet. I'm going to click OK. So now I have a pivot table inserted in a new worksheet. I'm going to go over here and I'm going to take the office, the city, I guess it is, and drag that down as a filter. Then I'm going to take the department, drag that down as a row in my table. And then I'm going to take the, because I want a count of employees, I need something that's unique. I'm going to click on Employee ID and drag it down as a value. And of course, that brings in the sum, which is not what we want. I'm going to click on that, drop down to Value Field Settings and select Count and click OK. That gives me the headcount in each of the departments in all the cities. First thing I want to do is select the city I'm interested in. I'm going to select Lana. I have now the city of Lana and the departments in the city of Lana or assigned to the city of Lana. I want to select some of these departments. So I'm going to click on the row labels drop down and I want to filter it. I'm going to unselect all and then I'm going to go down. I want to select the design department, the controller department. I'm going to drag down here, select finance, human resources and legal. And then the office of agriculture, just to give you the example, click OK. And now I've got those six departments and the headcount, the number of employees in each of those departments. So I can use them for the analysis I need. Hope this helps. And if it does help, please consider subscribing to my YouTube channel, the stats files. Just click the big red subscribe button.