I am looking at doing something like the one below but that is not working correctly.
![]()
=IF(INT(INDEX(average(Summary!$G$12:$P$13,1,MATCH(OFFSET($A$1, 0,INT((COLUMN()-1)/16)*16,1,1),Summary!$G$2:$P$2, 0))))=L$3, INDEX(average(Summary!$G$12:$P$13,1,MATCH(OFFSET($A$1, 0,INT((COLUMN()-1)/16)*16,1,1),Summary!$G$2:$P$2, 0))), "")
Bookmarks