Count distinct values

Overview

Count unique nonblank values in a selected range without changing cells.

Use this to quickly check how many customers, categories, or other unique entries appear in a range without building a separate formula.