Complicated search and complete analysis on results
Works great. Thanks!!
"marcus" wrote:
Hi elf4278
Sorry for the slow response I was in the land of nod. Yep that is
right the range is arbitrary. You change the range to whatever is
appropriate.
I would have a second table say it started in E2 with the names
John
Jane
Joe
Betsy
In F2 put =SUMPRODUCT(($B$2:$B$7=E2)*($C$2:$C$7))/COUNTIF($B$2:$B
$7,E2)
This would refer to John, drag this formula down and it will encompas
the other 'Editors' and do the same for the standard deviation
formula. Your range will probably go from $B$2:$B$122
Anyways good luck and if you have any trouble send me the
spreadsheet. Happy to help.
Marcus
|