本帖最后由 baksy 于 2014-7-4 16:46 编辑
F1公式,三键回车( 公式复制后,点一下公式编辑栏的任意位置,先按住 shift、ctrl 两个键,然后敲enter键。),
横拉、下拉;
=SUBSTITUTE(SUBSTITUTE(IFERROR(SMALL(IF(($A1:$E1<=(COLUMN()-5)*5)*($A1:$E1>(COLUMN()-6)*5),$A1:$E1),1),"")&","&IFERROR(SMALL(IF(($A1:$E1<=(COLUMN()-5)*5)*($A1:$E1>(COLUMN()-6)*5),$A1:$E1),2),"")&","&IFERROR(SMALL(IF(($A1:$E1<=(COLUMN()-5)*5)*($A1:$E1>(COLUMN()-6)*5),$A1:$E1),3),"")&","&IFERROR(SMALL(IF(($A1:$E1<=(COLUMN()-5)*5)*($A1:$E1>(COLUMN()-6)*5),$A1:$E1),4),""),",,,",""),",,","")