Want to count distinct values in an excel pivot table? This easy step-by-step guide will show you how to do this. It will also depend on your excel version

In the example shown, a pivot table is used to count the names associated with each color.