两个表格按人名汇总

猕猴桃一身毛

求助~领导从系统里导出会员表和流水表，要求按会员匹配成一个表格看一下会员的消费以及筛选出哪些消费没有进会员，求大神帮忙~感谢~


会员区配求助.rar (6.76 KB, 下载次数: 10)

2024-10-15 10:45 上传

点击文件名下载附件

acbczhhw

没看明白你的需求

wp231957

你要是补全流水表  可以实现  
=LET(xm,CHOOSECOLS(FILTER(J3:Q21,ISNUMBER(MATCH(J3:J21,A3:A10,0))),1),al,FILTER(I3:Q21,ISNUMBER(MATCH(J3:J21,A3:A10,0))),VSTACK({"会员姓名","来源","性别","年龄","电话","日期","顾客","产品","规格","数量","单价","折扣","消费","消费小计"},HSTACK(xm,XLOOKUP(xm,A3:A10,B3:B10),XLOOKUP(xm,A3:A10,C3:C10),XLOOKUP(xm,A3:A10,D3:D10),XLOOKUP(xm,A3:A10,E3:E10),al)))

猕猴桃一身毛

wp231957 发表于 2024-10-15 12:59
你要是补全流水表  可以实现  
=LET(xm,CHOOSECOLS(FILTER(J3:Q21,ISNUMBER(MATCH(J3:J21,A3:A10,0))),1), ...

太感谢啦~~~

sobili

最好用会员编号（唯一值）作关键字匹配，姓名可能会重复。