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.
Use this array formula
Code:=AVERAGE(IF($B$2:$B$17=B2,$E$2:$E$17))
Thanks xld, I'll try that.
How does the "$" function in that array?
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.
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.