=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1
HTH
Jason
Atlanta, GA
-----Original Message-----
I am trying to count various numbers and letters in
multiple cells that are
seperated by commas.
Example
a1 = 1,4
b1 = 3,89,3,16
c1 = 3a,4,7
I only want to count the number of unique entries in
each cell (meaning a1
would result in 2, b1 would result in 4, and c1 would
result in 3, etc.)
Is there a way to do this?
Please help. Thank you.
.
|