Get info from one column

[deVex]

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

[sweep]

Hi,

Could you use =COUNTIF(A:A,"Group1")

etc??

[deVex]

Thank you for reply.

I have arount 450 group names in the column and that will make do the command 450 times? Can I do some chart?

[sweep]

Easiest way is to use a pivot table.

Insert a pivot table, and use the group column as both the row labels and values.