Hi, probably a very easy one here, im looking to count the unique number of values within a single cell string which are separated by commas
example:
Cell A1 contains: 1,2,3A33,444,2,1,16
The resulting formula would give a count of 5 unique value within cell A1 as values '2' and '1' are repeated twice within the cell and would therefore be excluded.
Any help would be most appreciated, thank you!
example:
Cell A1 contains: 1,2,3A33,444,2,1,16
The resulting formula would give a count of 5 unique value within cell A1 as values '2' and '1' are repeated twice within the cell and would therefore be excluded.
Any help would be most appreciated, thank you!