EXCEL中如何将A列相同项所对应的B列数据按C列要求合并至D列,并且数 ...答:用代码解决,仅供参考:Sub test()Dim d, ar, br(), hz$, r%, c%, k%, y%Set d = CreateObject("scripting.dictionary")ar = Intersect([a1].CurrentRegion, [a:b])ReDim br(1 To UBound(ar), 1 To 2)For r = 1 To UBound(ar) hz = ar(r, 1) If Not d.exists...
excel中,如何将a列相同的值所对应的B列的值按行排列?答:形成数组公式 下拉到c11 在D1输入:=IF(C1="","",IF(COUNTIF($A$1:$A$11,$C1)<COLUMN(D1)-3,"",INDEX($B$1:$B$11,SMALL(IF($A$1:$A$11=$C1,ROW(D$1:D$11),300),COLUMN(A1)))&""))同时按 Ctrl+Shift+Enter, 形成数组公式 下拉到d11 右拉到若干列....