Counting unique values in Google Sheets is pretty easy and you can do it with a simple function. Let's see the step-by-step process.
2
First, open the spreadsheet document the you are working on. Then, select the cell where you want to see the results.
3
Then, you should type "=countunique"
4
You'll get the "COUNTUNIQUE" option below, so, click on it.
5
Then, select the data range that you want for the formula. You can do this by clicking, holding and hovering the mouse over cells that you need, or typing the range manually.
6
Once you have the range, close the bracket and hit the "enter" button.