I have some problem with the code.. I’m stuck with summing ‘COUNTA of PROBLEM INFO’ by ‘CODE’. I want to have for example: 0 –> (score) 11, 97 –> (score) 6.
SS
I tried to sum by xlookup or pivot tbl but it doesn’t work exactly as planned? any ideas?