Hello,
I have a sheet that is used for taking attendance, with names down the primary column and columns for each day of the week (mon, tues, wed, thurs and fri, etc for following weeks), plus one last column for the current attendance.
I need to pull the most recent value from the days of the week to show the current attendance. Is there a way to do that?
