=MODE(OFFSET(C$2,ROW(A1)*3-3,,,5))
MODE函数有点特殊，只能用辅助列替代内嵌公式K2=MODE(OFFSET(C2,L2,0,3,3))L2=(ROW(A1)-1)*3
=MODE(INDIRECT("c"&ROW(A3)*3-4):INDIRECT("G"&ROW(A3)*3-4))下拉公式即可
