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
345 Erin 2 no
345 Kate 0 no
345 Greg 0 no
What I want to solve for is-
Board member Usage (#boardmembers with logs per company>1/
#boardmembers per company)
Non Board member usage (#nonboardmembers with logs>1 per company/
#boardmembers per company)
For example,
Usage
---------
Team ABC usage = 33%
Team XYZ usage = 66%
Team 345 usage = 100%
Is there a way to do this in a macro? My main problem is finding a way
calculate by company name. Any help would be great
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
345 Erin 2 no
345 Kate 0 no
345 Greg 0 no
What I want to solve for is-
Board member Usage (#boardmembers with logs per company>1/
#boardmembers per company)
Non Board member usage (#nonboardmembers with logs>1 per company/
#boardmembers per company)
For example,
Usage
---------
Team ABC usage = 33%
Team XYZ usage = 66%
Team 345 usage = 100%
Is there a way to do this in a macro? My main problem is finding a way
calculate by company name. Any help would be great