Grouping and percentage calculations

[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?

 

[Nadine]

Do you have a "Group" column?

 

[randlesc]

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.