Group Column A data together

J

J.J.

Within this worksheet, I have 4 columns

Company Name #logs Boardmember
ABC Luis 1 yes
ABC Anne 1 yes
ABC Mary 9 yes
XYZ John 1 yes
XYZ Grace 4 no
XYZ Ben 8 yes
RJL Erin 2 no
RJL Kate 0 no
RJL Greg 0 no

I am calculating statistics but I am trying to do it by company. I'm
unfamiliar with ways group Column A data together based on name and am
wondering if there are other macro's similar to this. Usually I would
do this manually but the list has grown to over 50 companies and 2000
users and it's getting to be a pain in the butt.

For example,
Company ABC has 3 Board members out of 3 users
Company XYZ has 2 Board Members out of 3 users
Company RJL has 0 Board members out of 3 users
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top