P
Pammy
I have a large spreadsheet dating back from 2006, is there a way I can search
by a Detectives Name which is in Col K and then count the assigned offenses
in Col G, example:
Detective John Brown col k and then search col G, AA (Agg Assault) and give
me a total for Agg Assault, then change col G for Burg (Burglary) and give me
a total for Burglary, etc.
I have been counting by doing a filter, but I felt there could be an easier
way.
Thanks,
by a Detectives Name which is in Col K and then count the assigned offenses
in Col G, example:
Detective John Brown col k and then search col G, AA (Agg Assault) and give
me a total for Agg Assault, then change col G for Burg (Burglary) and give me
a total for Burglary, etc.
I have been counting by doing a filter, but I felt there could be an easier
way.
Thanks,