A
Anand
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
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