★★★Excel函数问题★★★

来源：百度知道 编辑：UC知道 时间：2024/06/23 03:30:53
见下图：
假如站号相同,则在C列输入扇区号,以逗号隔开,有没有用什么公式或者函数来实现简便的方法，在C2中应该怎样输入呢。（图中的数据为手动输入）
数据的规则就是如果站号相同，则在C列中输入扇区号，扇区号之间用","号隔开
(shuhua0715的方法的确可以做到，如果只要用一个公式就更好了）

d2=IF(A3=A2,B2&","&D3,B2)
c2=IF(A2<>A1,D2,"")

向下拖

数据规则是什么?我没看出来

c2输入

=IF(A1=A2,"",IF(A2=A3,B2,"")&IF(A3=A2,","&B3,"")&IF(A4=A2,","&B4,"")&IF(A5=A2,","&B5,"")&IF(A6=A2,","&B7,"")&IF(A7=A2,","&B8,"")&IF(A8=A2,","&B8,"")&IF(A9=A2,","&B9,""))
这个可以找到最多8个站号相同的，如果个数在多，可以修改公式添加

输入公式，选中c2向下拖就好了

这个可以最多有26个站号相同的
=IF(A1=A2,"",IF(A2=A3,B2,"")&IF(A3=A2,","&B3,"")&IF(A4=A2,","&B4,"")&IF(A5=A2,","&B5,"")&IF(A6=A2,","&B7,"")&IF(A7=A2,","&B8,"")&IF(A8=A2,","&B8,"")&IF(A9=A2,","&B9,"")&IF(A10=A2,","&B10,"")&IF(A11=A2,","&B11,"")&IF(A12=A2,",&q