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]

	A	B	C	D	E
1	Branch	FICO Score		Branch	Avg FICO Score
2	A	750		A
3	A	801		B
4	B	699		C
5	B	658
6	B	776
7	C	591
8	C	801

<tbody>
</tbody>

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

 

[63falcondude]

Glad to help.