更新时间:2023-01-12 21:37:06
您可以使用FILTER:
FILTER
=FILTER('Leads To Date'!A:C,COUNTIF('All Enrolled To Date'!A:A&'All Enrolled To Date'!B:B,'Leads To Date'!A:A&'Leads To Date'!B:B)=0)
基于与其他工作表匹配的列的Google工作表查询