How to perform Group By, Count on Excel

Hi Friends, I have data in excel as shown below:

Name Department
Mark Development
Henry Testing
John D Development
Alice Accounts
Arya Testing
Sansa Development
Emily Development
Erik Development
Rose Testing
Michale Testing

I want output :

Department Employee Number
Development 5
Testing 4
Accounts 1

How can I achieve ?

You can use Group By and select the output Department with the option Count Values.
But prior to that you should Sort Rows by Department.

Thanks Fernando. Its working.

badges