Question

求excel按出现次数归列公式

求excel按出现次数归列公式如图，求普通公式

Answer 1

根据你的描述，在K2单元格输入公式：
=IF($A2=K$1,$A$1,"")&IF($B2=K$1,$B$1,"")&IF($C2=K$1,$C$1,"")&IF($D2=K$1,$D$1,"")&IF($E2=K$1,$E$1,"")&IF($F2=K$1,$F$1,"")&IF($G2=K$1,$G$1,"")&IF($H2=K$1,$H$1,"")&IF($I2=K$1,$I$1,"")&IF($J2=K$1,$J$1,"")
复制并向右拉至N2单元格，选择K2-N2单元格复制并往下拉，即可实现你所有数据的显示了。
若是非要弄出个数据间的逗号来，则可在O2单元格输入公式：
=SUBSTITUTE(TEXT(K2,CHOOSE(LEN(K2)+1,"","0","0-0","0-0-0","0-0-0-0","0-0-0-0-0","0-0-0-0-0-0","0-0-0-0-0-0-0","0-0-0-0-0-0-0-0","0-0-0-0-0-0-0-0-0","0-0-0-0-0-0-0-0-0-0")),"-",",")
复制并向右拉至R2单元格，选择O2至R2单元格复制并下拉，则O-R列反映出的就是你要的数据和格式了。

Answer 2

代码不，代码不？

追问

代码不会，公式不?