名拼专题

Excel 将每组的前 3 名拼成串

分组明细表如下 ABC1ClientLocationSales2ABCNew York5,0003Florida4,0004Texas3,0005California2,0006Georgia1,0007XYZTennessee10,0008New Jersey8,0009Washington6,00010New York4,00011DEFOhio7,50012Colorado5,00013H