Return average from a range of cells, Excel 2003 1

[JohnB98121]

My spreadsheet has two columns with approx. 4,500 rows.

First column shows a filename beginning with a string to indicate firstly the date (in dd/mm/yyyy format) and then other details e.g. 26102016_abc.wav, 26102016_xyz.wav
There are about 250 rows for each date i.e. the sheet covers approx. 18 days data.

Second column shows a value, and there could be 250 different values for each date.

I am looking for a quick easy way to display the average value from the second column for each day , so the result displays 18 dates, each with their average value.

Thanks for your help.

JohnB

 

[JohnB98121]

Thanks for advice on Stars, Andy.