Hi,

I have a spreadsheet of products with details like barcode, retail
price etc. Many of the barcodes repeat (as I can source them from
several different suppliers with different cost prices). What I'd like
to do is use a function to group the barcodes and get an average of
their retail prices. Some sample data is below (i hope it displays
properly!):

BARCODE SUPPLIER CODE COST-EX COST-INC RETAIL
20048907 SUPPLIER A 35770 0.7583 0.8342 1.63
20048907 SUPPLIER B 10507404 0.7167 0.7883 1.54
20048907 SUPPLIER C S20008 0.6780 0.7458 1.45
20016296 SUPPLIER A 13178 1.9250 2.1175 4.13
9318120607063 SUPPLIER A 64406 2.5000 2.7500 5.36
9318120607063 SUPPLIER B 60156025 2.8500 3.1350 6.11
9318120607063 SUPPLIER D CM77YL 2.3800 2.6180 5.11
9310025083249 SUPPLIER A 17168 1.0583 1.1642 2.27
9310025083249 SUPPLIER B 10503901 0.9950 1.0945 2.13
9310025083249 SUPPLIER E 8324 0.8565 0.9422 1.84

So, using "9318120607063" as an example, I'd need it to find barcodes
that match, and average their retail prices (5.36, 6.11, 5.11). The
sheet is sorted on column A, so matching barcodes will all be
positioned together.

I think I need to use AVERAGEIF for this, but I'm not sure how to do
the barcode matching bit.

Any help would be awesome.

Thanks,
Simon.