I have a sheet where I calculate the average of a daily value for the past 30 days with a rolling average. I'd like to be able to pull the daily values and store them in a another sheet. I want to store the static values from that day. When I add in the next days data the average changes but I don't want the stored value to change.
Data source is stored in sheet "Workbook" with a list of names and that individuals average stored in A19:A30 and B19:B30 respectively. Output should be the name with the their average from a specific day. Ideally I'd like the output to be sorted in ascending order by average.
I hope this makes sense.