我在List Test22中有两个桌子
- ，水果买了买家购买！
，我想选择一个买家，并显示他不买的哪个泡芙
。
在TETS2表中 spreadsheets/d/1u0k3gfDjyWJm3UZlCp3dm1T6QnrM9k3o_9W8nnrvhJo/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1u0k3gfDjyWJm3UZlCp3dm1T6QnrM9k3o_9W8nnrvhJo/edit?usp=sharing
How to make column C "我没有购买的“显示买家没有购买的水果清单？
事实证明要比较两个列表，并显示您未购买的东西
= {query（evely（.....）而不是查询（...）），但这行不通（
Vlookup无法正常工作从左到右（
I have two tables
- In list TEST22, which fruits did the buyer buy!
https://docs.google.com/spreadsheets/d/1wOZWSPapMTnLGco4POGjsO2nKPdCNIiD_TCsfFjegPs/edit?usp=sharing
In the TETS2 sheet, I want to select a buyer and display which puffs he did not buy
There is a table with all fruits
https://docs.google.com/spreadsheets/d/1u0k3gfDjyWJm3UZlCp3dm1T6QnrM9k3o_9W8nnrvhJo/edit?usp=sharing
How to make column C "What I didn't buy" display a list of fruits that the buyer did not buy ?
It turns out to compare two lists and display what you didn’t buy
TRIED ={QUERY(.....) and not QUERY(...) ) but that doesn't work(
VLOOKUP won't work read data from left to right (
发布评论
评论（1）
使用：
use: