Forum Discussion
Formula help
I am trying to write a formula to search my sheet for a particular name and when that name is found, I would like to average a particular column values. There are multiple names on this sheet, but I ...
No the above won't work for me. What I'm trying to do is to find a formula that will give me the following:
I'm looking for an easy way to collect the average percentages for each person. My excel file has over 33,000 rows and I'm looking for an efficient way to calculate the average percentages for each person.
=IF(B3<>B4,AVERAGEIFS($C$3:C3,$B$3:B3,B3),"")You can enter this function in cell D3 and fill it down to row 33000.