[已解决]小菜鸟遇到个小问题,路过的达人帮我解决下~~

ldk7625

找出a,b,c,d对应的数......
新建 Microsoft Excel 工作表.rar (1.75 KB, 下载次数: 5)

2016-12-6 14:17 上传

点击文件名下载附件

最佳答案

月排行榜 / 总排行榜

砂海

2016-12-6 14:28

b10
=if($a$1=a10,b1&",","")&if($a$2=a10,b2&",","")
照着往后写

最后 C10
=right(b10,len(b10))
不然 参照2楼

跳转到最佳答案楼层

望帝春心

如果不动数据，大概需要用VBA吧

砂海

b10
=if($a$1=a10,b1&",","")&if($a$2=a10,b2&",","")
照着往后写

最后 C10
=right(b10,len(b10))
不然 参照2楼

苏子龙

论坛总有问此类问题，上传自定义函数contxt，供学习参考用

苏子龙

1. =TEXT(MID(SUM(IFERROR(SMALL(IF(A$1:A$10=A12,B$1:B$10),ROW($1:$9))/10^ROW($1:$9),)),3,99),0&REPT("、0",COUNTIF(A$1:A$10,A12)-1))

复制代码

简化一点后的函数

ldk7625

b11=IF(B$2="","",IF(B$2=A11,A$2&",",""))&IF(B$3="","",IF(B$3=A11,A$3&",",""))&IF(B$4="","",IF(B$4=A11,A$4&",",""))&IF(B$5="","",IF(B$5=A11,A$5&",",""))&IF(B$6="","",IF(B$6=A11,A$6&",",""))&IF(B$7="","",IF(B$7=A11,A$7&",",""))&IF(B$8="","",IF(B$8=A11,A$8&",",""))&IF(B$9="","",IF(B$9=A11,A$9&",",""))

c11=LEFT(B11,LEN(B11)-1)
最后这么解决的~