假设人名在A列，5人一组，则在B1输入=IF(ROW()>COUNTA(A:A)/5+1,"",ROW()&“组")然后下拉在C1输入=INDIRECT("a"&5*(ROW()-1)+COLUMN(A1))然后右拉到G1，再选中C1：G1，下拉复制到B列有数据的最后一行即可
=ROUNDUP(ROW(A1)/5,0)&"组" 下拉
