Hi,
Hope you all had a good Christmas. Is there a way to count the number of distinct values that appear in a column either by a formula or macro?
ie. in this list it would return the value 4 as orange appears twice so should only be counted once.
apple
orange
pear
orange
grape
Thanks in advance,
GW
Bookmarks