Couting data
I have a list of data A1:D130. ColA=Employee; ColB=Dept;
ColC=Rank; ColD=Group
I have a grid F2:O9. F3:F9 shows all ranks. G2:O2 shows
all 6 Groups.
I want to be able to type in a group no in ColD and have
this counted in the grid against rank.
For example, there could be 4 Chief Executives in Group 1,
or 7 Directors in Group 2.
How do I return count?
Thanks
Garry
|