函數(shù)法(多列匯總)--原創(chuàng)

歡歡

函數(shù)法(多列匯總)



提示輸入:

tmtony

歡歡,公式怎么寫(xiě)啊,沒(méi)看到公式哦

tanhong

多列匯總不錯(cuò),只是沒(méi)看到函數(shù)哦

pureshadow

這是個(gè)3*3矩陣轉(zhuǎn)一列的內(nèi)存數(shù)組公式.=IF((T(INDIRECT(TEXT(SMALL(ROW(A1:C3)*100+COLUMN(A1:C3),ROW(1:9)),"!r0c00"),))="")-COUNTBLANK(INDIRECT(TEXT(SMALL(ROW(A1:C3)*100+COLUMN(A1:C3),ROW(1:9)),"!r0c00"),)),N(INDIRECT(TEXT(SMALL(ROW(A1:C3)*100+COLUMN(A1:C3),ROW(1:9)),"!r0c00"),)),T(INDIRECT(TEXT(SMALL(ROW(A1:C3)*100+COLUMN(A1:C3),ROW(1:9)),"!r0c00"),)))
長(zhǎng)了點(diǎn),不過(guò)內(nèi)存數(shù)組有它的好處,可以在外面再進(jìn)行計(jì)算,非內(nèi)存的要做到這點(diǎn),只能加輔助列.

pureshadow

歡歡做的那種,可以自由增加的,之前也做過(guò),只是函數(shù)一時(shí)找不到了(再讓我做一次.......頭會(huì)破 )
等找到了,一定拿出來(lái)

pureshadow

或者爪MM自己拿出來(lái)

業(yè)余愛(ài)好者

不用那么復(fù)雜吧

我也做一個(gè)

=IF(ROW()>COUNTA($AA),"",A1)&(IF(ROW()<=COUNTA($AA),"",IF(ROW()<=COUNTA($AB),INDIRECT("B"&ROW()-COUNTA($A:$A)),"")))&(IF(ROW()<=COUNTA($A:$B),"",IF(ROW()<=COUNTA($A:$C),INDIRECT("C"&ROW()-COUNTA($A:$B)),"")))

業(yè)余愛(ài)好者

原帖由 pureshadow 于 2008-6-17 20:26 發(fā)表
這是個(gè)3*3矩陣轉(zhuǎn)一列的內(nèi)存數(shù)組公式.=IF((T(INDIRECT(TEXT(SMALL(ROW(A1:C3)*100+COLUMN(A1:C3),ROW(1:9)),"!r0c00"),))="")-COUNTBLANK(INDIRECT(TEXT(SMALL(ROW(A1:C3)*100+COLUMN(A1:C3),ROW(1:9)),"!r0c00"),)), ...

=IF(ROW()>COUNTA($AA),"",A1)&(IF(ROW()<=COUNTA($AA),"",IF(ROW()<=COUNTA($AB),INDIRECT("B"&ROW()-COUNTA($A:$A)),"")))&(IF(ROW()<=COUNTA($A:$B),"",IF(ROW()<=COUNTA($A:$C),INDIRECT("C"&ROW()-COUNTA($A:$B)),"")))

公式里怎么數(shù)據(jù)變成了表情了?

再來(lái)一次

還是不行,只好把文件也傳上來(lái)了


[ 本帖最后由 業(yè)余愛(ài)好者 于 2008-6-17 21:46 編輯 ]

pureshadow

禁用smiles就行了

pureshadow

相當(dāng)不錯(cuò)

[ 本帖最后由 pureshadow 于 2008-6-17 22:09 編輯 ]