美好的一天!我对床单很陌生,所以我希望问正确的问题。请查看以下示例文件的链接:
https://docs.google.com/spreadsheets/d/1eDBqzwsyakyP3RGWAdNKs76Ia7JOGFwjIl_czREU0s0/edit?usp=sharing
我想做的是,我想将时间表的4个选项卡合并为1,第一列在流程中合并(请注意,“ NAME”)列可能在第2周有其他条目,依此类推。在“组合”选项卡中获得该信息后,我将其与12个类似的工作表组合在一起。我希望我可以先完成此工作,我刚刚了解了importrange函数,希望您也可以向我提供一些提示,以帮助我加快创建合并文件的第二步。在此先感谢和感谢Stackoverflow员工!
采用:
=ARRAYFORMULA(IFNA({UNIQUE(QUERY({'Week 1'!A:A; 'Week 2'!A:A; 'Week 3'!A:A; 'Week 4'!A:A},
"where Col1 is not null", 1)),
VLOOKUP(UNIQUE(QUERY({'Week 1'!A:A; 'Week 2'!A:A; 'Week 3'!A:A; 'Week 4'!A:A},
"where Col1 is not null", 1)), 'Week 1'!A:H, COLUMN(B:G), 0),
VLOOKUP(UNIQUE(QUERY({'Week 1'!A:A; 'Week 2'!A:A; 'Week 3'!A:A; 'Week 4'!A:A},
"where Col1 is not null", 1)), 'Week 2'!A:H, COLUMN(B:G), 0),
VLOOKUP(UNIQUE(QUERY({'Week 1'!A:A; 'Week 2'!A:A; 'Week 3'!A:A; 'Week 4'!A:A},
"where Col1 is not null", 1)), 'Week 3'!A:H, COLUMN(B:G), 0),
VLOOKUP(UNIQUE(QUERY({'Week 1'!A:A; 'Week 2'!A:A; 'Week 3'!A:A; 'Week 4'!A:A},
"where Col1 is not null", 1)), 'Week 4'!A:H, COLUMN(B:G), 0)}))
然后使用:
=IMPORTRANGE("1eDBqzwsyakyP3RGWAdNKs76Ia7JOGFwjIl_czREU0s0", "Combined!A1:100")
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句