EXCEL数字由小到大次序排列?

CK2:=SMALL($CA2:$CI2,COLUMN(A1))或=IFERROR(SMALL($CA2:$CI2,COLUMN(A1)),)右拉，下拉。