如果为其他数据呢,有没有单元格的填充?
这么没办法批量处理啊。
追答不见表格,不敢妄言。第二个公式将数据显示在一个单元格中。=SMALL({3,2,5,10,11,20,1},1)&","&SMALL({3,2,5,10,11,20,1},2)&","&SMALL({3,2,5,10,11,20,1},3)&","&SMALL({3,2,5,10,11,20,1},4)&","&SMALL({3,2,5,10,11,20,1},5)&","&SMALL({3,2,5,10,11,20,1},6)&","&SMALL({3,2,5,10,11,20,1},7)
本回答被提问者采纳