and how many different types of animals you have overall. Because the functions you're about to use produce spilled arrays, and spilled arrays don't work in formatted Excel tables, you need to ...

Applying direct formatting to spilled arrays in Excel could cause issues ... Home tab on the ribbon—to visually separate the different types of rows in the data. However, if you later modify ...