如何与访问的普通城市匹配
目的是与特殊和正常状态相匹配，条件是他们有一个共同的城市。特别的名字应出现在E列中，正常名称应在F列中出现，并且由于它们俩都在同一城市或访问了同一城市而被匹配。
因此，数据转储将每天更新。因此，例如，特殊类型-Caroline已在剑桥访问。如果也有一种普通的类型访问了剑桥。因此，两者都访问了剑桥，这就是为什么它们是匹配的原因。
好的。另一个例子是，嗯，让我们在这里看看里贾纳。是一种特殊类型。现在，我们想将她与正常类型相匹配。因此，在这种情况下，没有匹配项，因此在结果中不会出现。
只有那些被标记为特殊或普通的人才能匹配。因此，比赛始终必须在特殊和诺纳尔之间，他们的名字必须出现在访问的城市。
使用过滤器功能认为它会奏效，当他们访问的城市中有一个通用的关键字时，它将自动检测到特殊和正常的情况，但它不起作用。
The goal is to match the special and the normal and the condition is that they have a common city. The special's name should appear in Column E and the Normal's name should appear in Column F and they're being matched because they both are in the same city or have visited the same city.
So the data dump that, um, will be updated on a daily basis. So for example, Type Special - Caroline has visited in Cambridge. If there's also a Type Normal that has visited Cambridge. Hence both visited Cambridge and that's why they were matched.
All right. Another example is, um, let's see here, Regina. Is a special type. Now we want to match her with a type Normal. So in this case, there are no matches, so that would not appear in the outcomes.
Only those who have been tagged as a Special or a Normal can be matched. So the match always has to be between Special and Nornal and their names just have to appear here at the visited city.
Using FILTER Function thought it would work out, that will automatically detect a Special and a Normal when there is a common keyword in a city that they visited in, but it isn't working.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
尝试：
更新：
try:
update: