Forum Discussion
count unique cell text values
Hi, I'm trying to create a formula which counts the unique number of country names in the second sheet of column S attached. I want the range to be the entire column since we're continuously adding d...
Thank you for your reply! I'm looking for a solution which won't require me to copy any values in column S. More data will be added to the column as time goes by, so the idea is to create a formula which will automatically update the unique text count (number of country names) in case a new country name happens to be added to the column. Is there a formula that would accomplish this?
Since you wanna count the number of unique countries, definitely, you must copy the data to a separate column and remove duplicates countries..
To automate your data, format the data in Excel Tables
To automate your data, format the data in Excel Tables