Hi,

please help me out with this function. I have summary of orders like bellow.
What i can tell to this is, that shipping prices are same for all AA orders in here. So i need to do average for every same names, which will be divided by Shipping price.
I have maximum 5 same Names... if this information helps you out.......

A1 Name | B1 Qty | C1 Shipping | D1 average function
aa | 1 | 1000 | something like =if(A2=A3;C2/Average(B2:B3)
aa | 3 | 1000 |
bb | 2 | 2000 |

Thanks for your helping me out......