I have run a script that has written several active directory groups and their members to an Excel sheet.

The group name is written to the A column and the username to the B column like this:

Group1 user
Group1 user
Group1 user
Group2 user
Group2 user
Group3 user
Group3 user
Group3 user
Group3 user

There are 44000 lines and I would like to sort them so I can found how many time Group1 have been written and then group2 and so on. This will help me found how many users are in Group1…

Thank you in advanced