Supposing you have a column of names in your Excel worksheet, and you need to count unique names in that column. The solution is to use the SUM function in combination with IF and COUNTIF: =SUM(IF(COUNTIF(range, range)=1,1,0))
https://www.ablebits.com/office-addins-blog/2016/04/07/how-to-count-distinct-and-unique-values-in-excel/
Here we have two rows and eleven columns so in this case Excel will automatically search the rows for the value and then return the value from the corresponding column. The LOOKUP function works in the same way that we would search for data as humans.
https://blog.udemy.com/excel-lookup/
Count distinct values in Excel (unique and 1st duplicate occurrences) To get a count of distinct values in a list, use the following formula: =SUM(1/COUNTIF(range, range)) Remember, it's an array formula, and therefore you should press the Ctrl + Shift + Enter shortcut instead of the usual Enter keystroke.
https://www.ablebits.com/office-addins-blog/2016/04/07/how-to-count-distinct-and-unique-values-in-excel/
Next we specify the table that Excel needs to search to find the data. This differs a little from LOOKUP because in the LOOKUP function we specified the column that contained the search value as opposed to the whole table.
https://blog.udemy.com/excel-lookup/
There are some formulas can help you to quickly count the number of unique values in a range. 1. Enter this formula =SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10)) into a blank cell. 2. Then press Enter key, and the number of the unique value will be displayed. Tips: 1.
https://www.extendoffice.com/documents/excel/1422-excel-count-unique.html
How to count distinct and unique values in Excel. by Svetlana Cheusheva Excel, Excel formulas, Excel functions, Excel tips 6 Comments. In this tutorial, you will learn how to count unique values in Excel with formulas, and how to get an automatic count of distinct values in a pivot table.
https://www.ablebits.com/office-addins-blog/2016/04/07/how-to-count-distinct-and-unique-values-in-excel/
How the LOOKUP function works. The LOOKUP function allows you to search a column of data for a specific value within Excel to return the corresponding value within another row. LOOKUP can be used to find values within rows or columns of data.
https://blog.udemy.com/excel-lookup/
How the Excel distinct formula works. As you already know, we use the COUNTIF function to find out how many times each individual value appears in the specified range. In the above example, the result of the COUNTIF function is the following array: {2;2;3;1;2;2;3;1;3}.
https://www.ablebits.com/office-addins-blog/2016/04/07/how-to-count-distinct-and-unique-values-in-excel/
Count the number of unique values with Formulas. There are some formulas can help you to quickly count the number of unique values in a range. If your data are numbers, for example, you have a column of numbers in range (A1:A10), see screenshot: You can use the following formulas, please do as this: 1. Enter this formula =SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10)) into a blank cell. 2. Then press Enter key, and the number of the unique value will be displayed.
https://www.extendoffice.com/documents/excel/1422-excel-count-unique.html
The next value we need to enter is the LOOKUP vector. This is the column or row that Excel must scan to find the value we are searching for. So we want to tell Excel to scan column B from row 6 to 10 to see if it can locate the value we need.
https://blog.udemy.com/excel-lookup/
excel function to determine how many different values in a column
In Excel function to determine how many different values in a column, 1. Enter this formula =SUMPRODUCT into a blank cell. 2. Then press Enter key, and the number of the unique value will be displayed. Excel function to determine different values in a column is SUMPRODUCT.