Count the Unique Entries in a range

A common question from Excel analysts and enthusiasts on my courses is to count the number of unique entries in a list.

This post looks at using a formula to calculate this distinct count.

Consider the list below of a list of delegates attending our courses. A normal count on this range will tell us how many attendances there were. That’s good, but we want to know how many unique attendees there were.

List of delegates

Continue reading