I have a sheet where I calculate the average of the 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 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.
The data source is stored in sheet "Workbook" with a list of names and that individuals average stored in A19:A30 and B19:B30 respectively. The output should be the name with 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.