关于"模糊查找并返回多个结果"的解决方案

朱先飞

=TEXTJOIN("、",,FILTER(B3:B14,REGEXTEST(C3:C14,E6)=TRUE))

要学习要学习

朱先飞 发表于 2024-10-1 22:53
=TEXTJOIN("、",,FILTER(B3:B14,REGEXTEST(C3:C14,E6)=TRUE))

2013版本没有TEXTJOIN

niko88819

就做成 TEXTJOIN 相似功能呗

=ConcatY(IF(ISNUMBER(FIND(I6,B3:B14)),A3:A14,", "))

1. Function ConcatY(FinalRng As Variant) As Variant
   
2. Dim first As Boolean
   
3. Dim c As Variant
   
4. first = True
   
5. ConcatY = "-"
   
6. For Each c In FinalRng
   
7.     If c <> "" Then
   
8.         If first = True Then
   
9.             ConcatY = c
   
10.             first = False
    
11.         Else
    
12.             ConcatY = ConcatY & "" & c
    
13.         End If
    
14.     End If
    
15. Next c
    
16. End Function
    

复制代码

ericxzhou

import pandas as pd

df = pd.read_excel('pandas exercise/sample473.xlsx', usecols='b:c', header=1)
df['人员'] = df['人员'].str.split('、')
df.explode('人员').groupby('人员').apply(lambda x: '、'.join(x['RD'].astype(str)))

要学习要学习

太难了