Tweet
I'm working with loan numbers and risk ratings (critical, high, med and low).
Say you have a data sheet that has been pivoted out in separate pivots based off risk. Each pivot has a category and then loan number in a single column.; this is repeated for each risk.
I am attempting to count a loan number only once even if it appears in multiple pivots with different risk, I want to count the highest risk loan ONLY. For example, if a loan is high risk but also has a medium risk, I don't want to return a value of 2, I would want a value of 1 and for the highest risk that appear, so the high column on my summary would have a 1 and the medium would show a 0.
I have all of this pulling up into a summary that has the categories in column A, my total loans with risk for each category in column B, columns C:F are each risk level.
Clear as mud?
Say you have a data sheet that has been pivoted out in separate pivots based off risk. Each pivot has a category and then loan number in a single column.; this is repeated for each risk.
I am attempting to count a loan number only once even if it appears in multiple pivots with different risk, I want to count the highest risk loan ONLY. For example, if a loan is high risk but also has a medium risk, I don't want to return a value of 2, I would want a value of 1 and for the highest risk that appear, so the high column on my summary would have a 1 and the medium would show a 0.
I have all of this pulling up into a summary that has the categories in column A, my total loans with risk for each category in column B, columns C:F are each risk level.
Clear as mud?
Comment