Grouping and percentage calculations

  • Thread starter Thread starter randlesc
  • Start date Start date
R

randlesc

I have a worksheet which currently is organized by UNITS/Divisions in our
company. Following the manager's name I have four columns each for a
different annual compliance. If they are compliant it says YES; if the
person is not compliant the cell is blank.

Currently I've been copying and pasting a percentage formula into cells
immediately beneath these after each break in group. However, each time I
copy, I have to adjust the formula to include the beginning of the group--it
always catches the end of the group.

I would like to automate this. Any suggestions?
 
Yes, my columns are:

UNIT (the group), NAME, ID#, SUPERVISOR, MANAGER, ADMINISTRATOR, COMPLIANCE
1, COMPLIANCE 2, COMPLIANCE 3, COMPLIANCE 4.

I already have spaces between each group--I realize I was unclear about that.

I'm really interested in how to put percentage compliant in the appropriate
cells beneath each column.

Thanks.
 
Back
Top