A and B columns are both sourced with data from another worksheet - A
is always a 2 letter code, eg. "Re" or "Ca", and B is always a numeric.
I want to keep the workbook macro-free so without using macros to sort
or subtotal the columns first, how can I calculate the percentages of
each code's numerics, so I can present these on another sheet?