See how to count unique values in Excel with a formula and get an automatic count of all different values in a pivot table. Learn formulas for counting unique names, texts, numbers, case-sensitive unique values, and more.