help with multiple conditional statements

Occasional Visitor

I was hoping someone could help me format this. I want to compare a series of 7 numbers looking for differences. While comparing those numbers, any two numbers that are different, I would like to return with an I, and any time the numbers are the same, it will return nothing. I want to be able to visually see (as in a rudimentary graph) how many differences there are by stacking the letter I. So, if all 7 numbers are different, there should be 7 I's, if two of the seven are duplicates, there should be 5 I's, etc.

Desired outcome:


1 Reply


In H11:  =REPT("I",SUMPRODUCT(IF(FREQUENCY(A11:G11,A11:G11),1)))

Fill down.