EXCEL 多个单元格值,选大于1中的前3个设置条件格式,答:在J1单元格输入公式=INDEX($A1:$H1,SMALL(IF($A1:$H1=MAX($A1:$H1),COLUMN($A1:$H1)-1,5000),1))&INDEX($A1:$H1,SMALL(IF($A1:$H1=MAX($A1:$H1),COLUMN($A1:$H1)-2,5000),1))&INDEX($A1:$H1,SMALL(IF($A1:$H1=MAX($A1:$H1),COLUMN($A1:$H1)-3,5000),1))数组...