请高人帮忙解决一个Excel的问题？见图片，不甚感激！！！
Excel\u95ee\u7b54\u9898\uff0c\u9ad8\u4eba\u5e2e\u5fd9\u89e3\u51b3\u4e0bDDBBA DAABC
\u795d\u4f60\u5b66\u4e60\u6109\u5feb\uff01
\u5728\u8868\u683c\u4e2d\u533a\u57df\u4e2d\u8f93\u5165\u4f60\u8981\u7684\u6570\u636e\u5185\u5bb9\uff0c\u70b9\u63d2\u5165\u56fe\u8868
\u5728\u56fe\u8868\u5411\u5bfc\u9009\u62e9\u81ea\u5b9a\u4e49\u7c7b\u578b\uff0c\u5728\u81ea\u5b9a\u4e49\u7c7b\u578b\u4e2d\u9009\u4e24\u8f74\u7ebf-\u67f1\u56fe
\u90c1\u95f7\uff0c\u5ea6\u5a18\u63d0\u793a\u5df2\u4e0a\u4f20\u7684\u56fe\u7247\u8d85\u51fa\u9650\u5236\uff0c\u6211\u72c2\u6655\uff01
\u65e0\u8bed\uff0c\u540e\u9762\u7684\u56fe\u793a\u53d1\u4e0d\u4e86\uff01
\u5177\u4f53\u770b\u9644\u4ef6\uff01
=IF(COUNTIF(Sheet1!$A:$A,$A2)>=INT(COLUMN(Sheet1!B2)/2),INDEX(Sheet1!$B:$B,SMALL(IF(Sheet1!$A$2:$A$10=$A2,ROW($2:$10),4^8),COLUMN(Sheet1!B1)/2)),"")
sheet2的C2单元格输入公式,,按SHIFT+CTRL+ENTER三键
=IF(COUNTIF(Sheet1!$A:$A,$A2)>=INT(COLUMN(Sheet1!B2)/2),INDEX(Sheet1!$C:$C,SMALL(IF(Sheet1!$A$2:$A$10=$A2,ROW($2:$10),4^8),COLUMN(Sheet1!B1)/2)),"")
选择B2:C2,向右填充
然后再向下填充
公式经过测试验证,如有疑问,可加510809100索要原表
不见表格不好做的，意思明白了，因为的人的数据量大，只简单说一下根本解决不了问题的！
绛旓細鍔犲叆A1涓绠楀紡鍓嶆病鏈夆=鈥濓紝鍒欏湪B1涓緭鍏 =鈥=鈥&A1 鐒跺悗涓嬫媺B1鍗曞厓鏍煎叕寮忓埌B鍒楀叾浠栬 閫変腑B鍒楁墍鏈夋暟鎹锛屾墽琛屽鍒垛斺旈夋嫨鎬х矘璐粹斺旀暟鍊 鍐嶉変腑B鍒楁墍鏈夋暟鎹紝鎵ц鈥滄浛鎹⑩濓紝鍦ㄢ滄煡鎵惧唴瀹光濊緭鍏モ滐紳鈥濓紝鍦ㄢ滄浛鎹负鈥濊緭鍏モ滐紳鈥濓紝纭畾灏監K浜 濡傛灉A1鍗曞厓鏍艰绠楀紡鍓嶆湁鈥滐紳鈥濓紝灏嗗叕寮忎慨鏀逛负 锛...
绛旓細鎶婁袱琛岄儴鍒嗙殑涓嬩竴琛屾斁鍦ㄤ笂涓琛岀殑鍚庨潰銆 鍗斥滆壊鍙/鏁伴噺鈥濈敱鍘熸潵鐨4鍒楁敼涓8鍒椼
绛旓細杩欎釜闂鎸夐涓荤殑瑕佹眰鐨勭‘闇瑕乂BA鏉瑙ｅ喅锛屼絾闂鏄繖鏍涓涓绠鍗曠殑宸ヤ綔琛ㄦ槸鍚﹀煎緱鎼炲緱杩欎箞澶嶆潅銆傚鏋滄病鐞嗚В閿欙紝棰樹富鐨勮姹傛槸缁熻鍏ㄥ勾浠庡厓鏈堝埌褰撳墠鏈堜唤鐨勬绘暟锛屽浜ч噺涔嬬被銆傞偅涔堜綍涓嶅湪C鍒楁潵缁熻鍛紝B鍒楄繕鍙繚鐣欐瘡涓湀鐨勪骇閲忔暟鎹傝繖鏍烽棶棰樺氨鐩稿綋绠鍗曚簡锛屽湪C1涓緭鍏ュ叕寮忥細=IF(B1="","",SUM(B$1:B1)...
绛旓細D$1:D10="")*ROW(D$1:D10)-1,65536)+1,ROW(A1)))C1锛="XXX"&TEXT(INDIRECT("sheet2!b"&SMALL(MOD((Sheet2!D$1:D10="")*ROW(D$1:D10)-1,65536)+1,ROW(A1))),"yyyy-m-d")娉ㄦ剰锛氭瘡涓叕寮忚緭鍏ュ畬姣曞悗鍚屾椂鎸夛細Ctrl+Shift+Enter涓変釜閿紙鍏紡涓ょ浼氬嚭鐜颁竴瀵瑰ぇ鎷彿{}锛...
绛旓細浣犳槸鎯冲畬鎴愭垜鍥剧墖涓殑閭ｆ牱鍚,鍚嶅瓧鍚庨潰鐨勪袱涓崟鍏冩牸鍒嗗埆鏄夐」閫変粬鐨勬妧鏈瓑绾у拰宸ョ,鐒跺悗绗笁鍒楄嚜鍔ㄥ嚭鏉ュ伐璧勬槸鍚,閭ｄ釜鍥鹃噷灏辨湁鐩稿簲鐨勫叕寮忎簡 涔熷彲浠ユ妸鍏紡 鏀规垚 =INDEX(A:D,MATCH(I1,A:A,0),MATCH(J1,A$1:D$1,0))
绛旓細鍦℉1涓緭鍏ユ垨澶嶅埗绮樿创 =SMALL($A1:$F1,COLUMN(A:A))鍙虫媺濉厖鍒癕1 閫変腑H1:M1,涓嬫媺濉厖銆
绛旓細鍗曞嚮鑿滃崟涓殑瑙嗗浘鈥斺斿伐鍏锋爮鈥斺旂粯鍥撅紝鍦ㄨ〃鏍间笅鏂瑰脊鍑虹殑缁樺浘涓鏍忎腑閫夋嫨鈥滄枃鏈鈥濓紝鍒╃敤鏂囨湰妗嗚緭鍏ワ紙鍥剧墖涓樉绀虹殑鏈鍚涓涓锛夛紝鎯虫嫋鍒板摢灏卞埌鍝簡
绛旓細1.鏁版嵁鍓嶅悗鏄惁鏈夌┖鏍笺傛湁鐨勮瘽鏇挎崲鎺 2.鍒楁暟鎹牸寮忔槸涓嶆槸鏂囨湰鐨勩傚氨鏄甫缁胯壊灏忔爣璁帮紝鎴栬呭墠闈㈡湁鍗曞紩鍙风殑銆傜敤鏁版嵁-鍒嗗垪锛屽垪鏁版嵁鏍煎紡璁剧疆鎴愭枃鏈3.姹傚拰鐨勬椂鍊欐槸涓嶆槸鎶婂啓鍏紡鐨勫崟鍏冧釜涔熷紩鐢ㄤ簡銆傚啀涓...灏辫繖涔堝浜
绛旓細=SUMIF($A:$A,"1",$B:$B)"1"涓篈鍒椾骇鍝佸瀷鍙凤紝闅忔剰鏇存崲銆
绛旓細鍙互浣跨敤VBA涓姝ュ埌浣 绗簩涓棶棰 鐩存帴鍦ㄧ瓫閫夊悗鎶婄紪鍙烽噸鏂版洿鏀逛负1锛2锛3杈冨洶闅撅紝浣嗗彲浠ヤ娇鐢涓涓鍑芥暟缁熻绛涢夊嚭鐨勫叡鏈夊灏戣锛岀敤SUBTOTAL鍑芥暟鍗冲彲 绗笁涓棶棰 蹇呴』浣跨敤VBA鏉ユ縺娲绘棩鏈熷垽鏂 鏃犲疄闄呮渚嬶紝鏃犳硶涓涓璇存槑锛屽彧鑳藉氨姝ら棶棰樿鏄庡熀鏈殑鎬濊矾鍜屾柟娉曪紝鍏蜂綋鎯呭喌锛岄渶瑕佽繘涓姝ヤ簡瑙ｆ墠鑳瑙ｅ喅 ...
