Hi all,
Not quite sure how to express this, but at my work we have a spreadsheet where we record outcomes for people (In a legal setting). Every person is input into this spreadsheet and given a number to identify that person, and the cases they may have.
I've attached a screenshot of some example data to give some context.
Example.PNG
So from above, you can see that Column A, the person is given the number of 1, the next person is allocated 2 etc etc. I'm trying to treat this number as the primary key.
At the end of the day we currently manually count the outcomes for people, but I'm trying to automate this to save time
What I need to try and figure out, is if there is a way to set up formulas to count relying on the Number in Column A. For example, using the Column A value and then reading in the cells in Columns U and V to count the results only for that person, and the same for Person number 2 and so on and so forth.
In the above example, the correct result that I would need to return is that one Remand Order is made for person number one. But for a bit of added complexity, the result I need to count may not be in the first row, but could be in any other row applicable to person Number 1. In effect there are a few outcomes we can enter, Remand, Bailed, Finalised or Adjourned. Some cases can have combinations of these outcomes, and I'll need to set up a hierarchy for which outcome overrides the other for when we take our stats.
Unfortunately the boss isn't keen on me changing the design of this spreadsheet, so I'm just trying to see if there's a way to do it without making any drastic changes.
If anyone would have any suggestions, I'd be incredibly grateful.
Cheers,
Bookmarks