Google Sheets - pull static value from cell that will change later

by Lance Salmikivi   Last Updated June 13, 2019 02:03 AM

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.

Tags : google-sheets


Related Questions


Updated March 03, 2018 02:03 AM

Updated September 19, 2018 13:03 PM

Updated June 10, 2019 17:03 PM

Updated July 26, 2018 21:03 PM

Updated November 29, 2018 16:03 PM