關于excel字符串拼接雙引號，excel字符串拼接這個問題很多朋友還不知道，今天小六來為大家解答以上的問題，現(xiàn)在讓我們一起來看看吧！
1、設數據如圖:將公式 =IF(B2=B1,"",B2) 復制后粘貼到"C2"單元格;將公式 =IF(C2="","",IF(SUM(C2:C8)=C2,A2&","&A3&","&A4&","&A5&","&A6&","&A7&","&A8,IF(SUM(C2:C7)=C2,A2&","&A3&","&A4&","&A5&","&A6&","&A7,IF(SUM(C2:C6)=C2,A2&","&A3&","&A4&","&A5&","&A6,IF(SUM(C2:C5)=C2,A2&","&A3&","&A4&","&A5,IF(SUM(C2:C4)=C2,A2&","&A3&","&A4,IF(SUM(C2:C3)=C2,A2&","&A3,A2))))))) 復制后粘貼到"D2"單元格,將"C2:D2"二個單元格選中,對準"D2"單元格右下角,光標成"+"狀時雙擊(或拖下去),效果如圖:注意:一、用此方法必須對"B"列排序;二、如果同一分數從數超過7人,可將公式 =IF(C2="","",IF(SUM(C2:C14)=C2,D2&","&A9&","&A10&","&A11&","&A12&","&A13&","&A14,IF(SUM(C2:C13)=C2,D2&","&A9&","&A10&","&A11&","&A12&","&A13,IF(SUM(C2:C12)=C2,D2&","&A9&","&A10&","&A11&","&A12,IF(SUM(C2:C114)=C2,D2&","&A9&","&A10&","&A11,IF(SUM(C2:C10)=C2,D2&","&A9&","&A10,IF(SUM(C2:C9)=C2,D2&","&A9,"")))))))復制后粘貼到"E2"單元格,將公式雙擊下去,如圖:。
本文分享完畢，希望對大家有所幫助。
標簽：
免責聲明：本文由用戶上傳，如有侵權請聯(lián)系刪除！