| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to build macro to do calculations by grouping column A by name
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 company1/ #boardmembers per company) Non Board member usage (#nonboardmembers with logs1 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Grouping and percentage calculations | Excel Worksheet Functions | |||
| Pivot Tables, Grouping, and Calculations | Excel Discussion (Misc queries) | |||
| Running Calculations to build chart | New Users to Excel | |||
| Can you build a dialog box to fill a column | Excel Programming | |||
| How to build build a macro that automatically imports | Excel Programming | |||
Threaded Mode
