Microsoft Excel GROUP BY

Tags:
Microsoft Excel
How can I list the departments and the number of employees in each department?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

The easies way is to sort the data by department and add a subtotal count on the employee ID.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    Assuming you wanted to count the total number of employees belong to department/department wise. For this purpose, either you can use COUNTIF function Or use pivot table.
    140,720 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: