Finding Average for Multiple sets of data within a document

[Paynter3420]

I have project for work where I need to find the average fico score for each branch within an excel file. The way i have been doing it is just filtering the branch number and then finding the average that way. Although this works, I have around 1000 branches i need to do this for. Any tips to make this process go faster? Thank you.

 

[63falcondude]

You might be able to use the AVERAGEIF function. If the branch is whatever then take the average of these numbers.

 

[Paynter3420]

Thanks so much!

 

[63falcondude]

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Branch[/TD]
[TD="align: center"]FICO Score[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Branch[/TD]
[TD="align: center"]Avg FICO Score[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]801[/TD]
[TD="align: center"][/TD]
[TD="align: center"]B[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]699[/TD]
[TD="align: center"][/TD]
[TD="align: center"]C[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]658[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]776[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]591[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]801[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

In cell E2; =AVERAGEIF(A:A,D2,B:B)
Copy this down to cell E4.

 

[63falcondude]

Glad to help.