How did you get there so quickly?

Thirty years of birding. Oh you meant the calculation?

In Libre Office:

1. Copy and paste eBird life list into spreadsheet. This all ends up in a single column and needs to be massaged to make it usable. Ugh.

2. Remove all columns except for genera and then sort alphabetically. This is column A

3. Add a new column with formula to check if adjacent cells are the same (i.e., B1 = EXACT(A1,A2))

4. Sort on B. You will see all FALSE as you scroll down, and eventually the first TRUE - call that row x. The number of distinct genera in the list is x-1.

This is why I don't like excel-like spreadsheets. All this manual futzing around - almost as bad as the legwork you have to do to make a histogram or run a model. At my work for the last 21 years, I always used JMP, a statistically saavy spreadsheet-like program made by SAS. You could get the # genera in this example, along with histograms and lots of other statistical measures, with the click of a single button. As it should be. But alas I am retired now and the JMP software is too crazy expensive.

If I really need to parse some complex data set or lists, I usually just write Python code. I probably could have done the genera calculation with fewer total keystrokes in that way, but I was not in a coding mood yesterday.