Hi,
I have two columns: a list of items and a list associated prices. How do I calculate the average price for the items that are repeated. I have given an simplified list as an example. the number next to the item represents the price:
Green Apple 0.56
Green Apple 0.60
Green Apple 0.51
Red Apple 0.35
Red Apple 0.31
Grape 0.89
Pear 0.47
Pear 0.45
Pink Grapefruit 0.61
Pink Grapefruit 0.59
Pink Grapefruit 0.63
Pink Grapefruit 0.57
Red Grapefruit 0.56
White Grape Fruit 0.74
White Grape Fruit 0.73
White Grape Fruit 0.81
How would I find the average price of each fruit type automatically. I have tried using IF functions but ended up with too many arguments. I feel I want to tell excel to check if an item is repeated and if so, calculate an average of the numbers in the same row...but I cannot figure it out. Please help!
Bookmarks