Should B1 be 3 or 4 (3 is a lot more tricky)?
--
HTH
RP
(remove nothere from the email address if mailing direct)
"clubin" wrote in 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.
|