Here's another view & venture on your original post ...
Source data is assumed running in Sheet2's A2:B2 down,
eg:
Tigers 4
Lions 2
Bears 3
Lions 7
Bears 5
Tigers 9
etc
In Sheet1,
With the unique "animals", eg: Tigers, etc listed in A2 down
Paste this into B2, then press CTRL+SHIFT+ENTER to confirm the formula:
=AVERAGE(IF(Sheet2!A$2:A$100=A2,Sheet2!B$2:B$100))
Copy B2 down. Adapt the ranges to suit the actual extents of your data.
Success? High-five it, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---