Jun 16 2021 01:44 PM
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:
Jun 16 2021 02:05 PM
SolutionJun 16 2021 02:05 PM
SolutionIn H11: =REPT("I",SUMPRODUCT(IF(FREQUENCY(A11:G11,A11:G11),1)))
Fill down.