in
a1
1234
a2
1123
a3
2244
a4
4443
a5
5555
i am trying to come up with a formula that will do the following
if the number in cell a1 has no duplicates, b1="s"
if the number in cell a1 has 1 duplicate, it should "1d"
if the number in cell a1 has 2 duplicate, it should "2d"
if the number in cell a1 has 3 duplicate, it should "tc"
if the number in cell a1 has all duplicate, it should "qc"
what im expecting is
b1=s
b2=1d
b3=2d
b4=tc
b5=qc
a1
1234
a2
1123
a3
2244
a4
4443
a5
5555
i am trying to come up with a formula that will do the following
if the number in cell a1 has no duplicates, b1="s"
if the number in cell a1 has 1 duplicate, it should "1d"
if the number in cell a1 has 2 duplicate, it should "2d"
if the number in cell a1 has 3 duplicate, it should "tc"
if the number in cell a1 has all duplicate, it should "qc"
what im expecting is
b1=s
b2=1d
b3=2d
b4=tc
b5=qc