Excel: Need to sort multi-year data by week by stationID- please - Microsoft Community

hello,

i have data set has daily readings (which have sorted weeks) weather stations. need sort data ot weekly averages of variables weather station. have attached screenshot of workbook, including example (top line only) showing averages need. found online can done pivot table, not figure out how workted weekly average station. great!

ex: d2 average of akr02's week 18 data in column e. 

     f2 average of akr02's week 18 data in column g...etc.

thanks,

mary

have found answer going suggest, pivot tables. still in process of learning them myself can't give specific instructions.

generating sums, pivot tables can calculate averages. have group data appropriately

can provide links these free 1hr each (approx) pivot table webinars. if don't have time view them right now, suggest download of them. pretty sure recall seeing mention of generating averages in 1 of them. don't have buy courses shilling @ end lot of benefit watching them.

myonlinetraininghub 3 pivot table webinars - https://www.myonlinetraininghub.com/excel-dashb...

myonlinetraininghub 1 power bi dashboard webinar - https://www.myonlinetraininghub.com/excel-dashb...

myexcelonline 2 pivot table webinars - https://www.myexcelonline.com/free-excel-webinars

tip may
monthly average vs current year chart https://www.excelcampus.com/charts/monthly-aver...
learn how create interactive chart displays monthly averages versus current year. continue reading jon acampora april 20, 2015




here different approach:
convert pivot table sumifs formulas – free vba macro
https://www.excelcampus.com/vba/convert-pivot-t...
post contains free vba macro convert pivot table report containing sumifs, countifs, or averageifs formulas. if want quick way create long sumifs formula, ticket.
jon acampora october 14, 2014

Office / Excel / Windows 10 / Office 365 Home