SOLVED

help with multiple conditional statements

Copper Contributor

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
best response confirmed by KadieB (Copper Contributor)
Solution

@KadieB 

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

Fill down.

1 best response

Accepted Solutions
best response confirmed by KadieB (Copper Contributor)
Solution

@KadieB 

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

Fill down.

View solution in original post