I have documents with say 38,000 lines and poss ten cols
With auto filter on I can select a species in col A and then I want to know
how many different locations it was found at which is listed in col B. At
present I hold the auto filter down on col B and actually count down the
list! There must be a better way.
Help please!