Use this formula in C1 and copy down to bottom of your range:
=SUMPRODUCT(--($A$1:$A$1000=A1),--($B$1:$B$1000))/SUMPRODUCT(--($A$1:$A$1000=A1),--($B$1:$B$1000<""))
--
Regards,
Dave
"dnm" wrote:
Hello -
I have a range of names in column A and a range of ages in column B. How
can I determine the average age per unique name?
|