Excel

Formulas

Non Breaking Space (Mac)

// Place the following formula in a cell
=char(202)

// past values
// copy pasted values into find/replace box

Count Unique Values of Text in Range of Cells

=SUM(IF(FREQUENCY(MATCH(B2:F2,B2:F2,0),MATCH(B2:F2,B2:F2,0))>0,1))

 

 

Code