I've a sheet with two option buttons (grouped). The data goes like
A B C
Name Process Role
x a Agent
y a Agent
z a Agent
m b TL
n b MIS
o a MIS
p a TL
q b Agent

I want results in a table where results are dependent on option button
the user selects. e.g. if the user selects Option 1 which is for
process a
Agent 3
TL 1
MIS 1

similarly if the user select option 2 which is for process b the
result should be

Agent 1
TL 1
MIS 1

How can this be achieved using a formula in Excel 2003. I don't know
much of VBA still if code is there it would also be welcome

Thanks,
Anand