EXCEL A列数据每4行一段取最大值和最小值按原来顺序自动排列在B列

Question

如题所述

Answer 1

B1=IF(OR(MAX(OFFSET($A$1,(INT(ROW(A4)/4)-1)*4,,4,))=A1,MIN(OFFSET($A$1,(INT(ROW(A4)/4)-1)*4,,4,))=A1),ROW()*100+A1/10000,4^8)向下复制

C1=IF(SMALL(B:B,ROW(A1))=4^8,"",MOD(SMALL(B:B,ROW(A1)),1)*10000)向下复制

Answer 2

b1输入：
=MAX(INDIRECT("A"&ROW()*2-1&":A"&ROW()*2+2))
b2输入：
=MIN(INDIRECT("A"&ROW()*2-3&":A"&ROW()*2-1))
同时选中b1、b2，然后下拉即可。本回答被提问者和网友采纳