JohnB98121
Technical User
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
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