Peoples,
Could someone do a good deed an help me manage this disgrace of a formula into something more succinct?
As you'll see it's calculating the frequency of 'yes' against the frequency of 'yes' and 'no' depending on the condition in B5 is met. It's actually part of a much larger formula...