求用excel公式寻找显示4列数据
=CHOOSE(COLUMN(A1),MAX(OFFSET($B$2,(ROW()-3)*4+1,,4)),MIN(OFFSET($B$2,(ROW()-3)*4+1,,4)),OFFSET($D$2,(ROW()-3)*4+1,),OFFSET($E$2,(ROW()-2)*4,))
热门标签:
=CHOOSE(COLUMN(A1),MAX(OFFSET($B$2,(ROW()-3)*4+1,,4)),MIN(OFFSET($B$2,(ROW()-3)*4+1,,4)),OFFSET($D$2,(ROW()-3)*4+1,),OFFSET($E$2,(ROW()-2)*4,))