英文:
Find contacts from a large database via keyword
问题
早上好，
寻求一些支持，这是超出了我基于公式的知识范围（我不懂VBA！）
我从互联网上下载了一个大型联系人数据库（付费引导生成网站），其中每家公司最多包含50个联系人。我被要求筛选出只包括以下内容：公司（最左边的列），以及工作职务包含“Innovation”一词的任何人的名字、姓氏、职称和电子邮件地址。我尝试过几种不同的方法（FILTER、XLOOKUP和LEFT/RIGHT公式），但还没有找到解决方法。
我附上了一个链接，这样你就可以看到我的意思。显然我不能包括图像或附件。
有任何想法，我将不胜感激！
谢谢，
Rob
英文:
Good morning all,
Looking for some support with a challenge that is outside my formula-based knowledge (I don't have any VBA knowledge!)
I have a large contacts database downloaded from the internet (paid lead gen website) which contains up to 50 contacts per company. I've been asked to filter out so that I only have the following: Company (left-most column), and the first name, surname, job title and email address of anyone whose job title contains the word "Innovation". I've tried a couple different ways around it (FILTER, XLOOKUP and LEFT/RIGHT formulae) but not figured anything out yet.
I've attached a link so you can see what I mean. Apparently I can't include images or attachments yet.
Any ideas I'd be extremely grateful!
Thanks,
Rob
答案1
得分: 1
在数据中似乎存在某种模式，因此尝试：
单元格A6中的公式：
=LET(x,WRAPROWS(TOCOL(B1:M3,3),4),FILTER(x,ISERR(FIND("创新",INDEX(x,,3)))-1))
英文:
There seems to be a certain pattern in the data, so try:
Formula in A6:
=LET(x,WRAPROWS(TOCOL(B1:M3,3),4),FILTER(x,ISERR(FIND("Innovation",INDEX(x,,3)))-1))
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论