Excel Count Unique Values in a Cell - and the Entire Range that Cell Resides In - SOLVED
I have a worksheet that has a column of cells but each cell has one to several field names. I find lots of guidance on counting unique values in a range of cells BUT not within cell and ranges. The values in the cells are alphanumeric field names such as COLCOD, A15OB, ACCTNO etc. The goal if not clear (the worksheet that this column is in has roughly 400 rows) is to count the unique instances of fields in the entire column BUT considering one cell in that column may have several fields as noted above. M
This question generated 23 answers. To proceed to the answers, click here.