In cell J10 I need to enter a INDEX function that will convert the Call Day to the actual weekday found in row 1 of the DayofWeek named range and I need to run advanced pivot tables with filter using the criteria range A1:J2.
Solved by C. C. in 28 mins