This repository was archived by the owner on Oct 26, 2021. It is now read-only.

Count Distinct Entries in a Range #7

WayneLambert announced in Excel Guides

WayneLambert
Oct 26, 2021
Maintainer

Formula to count the number of distinct entries in a range:

=SUM(--(FREQUENCY(Table1[RangeData],Table1[RangeData])>0))

Replies: 0 comments

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment