Average of Values in Column E for each value in Column B - help

[Foxtrot]

I have a list of vendors (organized by vendor number) in Column B of my worksheet. Column E is a list of the # of days it took the vendor to get product to me.

I need a macro that will search for like values in column B and then average the values in Column E of the corresponding Rows. I need it to report the result in Column F in each of those Rows.

[Bob Phillips]

Use this array formula


=AVERAGE(IF($B$2:$B$17=B2,$E$2:$E$17))

[Foxtrot]

Thanks xld, I'll try that.

How does the "$" function in that array?

[Foxtrot]

Actually, that doesn't work right.

The result is the average of every cell value in Coumn E. I just want the averaged result of the Column E values that correspond with the like values in Column B.

[Aussiebear]

Please use Control Shift Enter when you enter the formula. The results will then show A10256 has an average of 7.75 days, B10110 an average of 8.75 etc.