在Google表中，我需要找出基于时间卡数据在给定位置的给定轮班的50％以上的员工工作（Col G：J）。在附带的Google表中，我需要C列中的公式，该公式返回匹配员工的名称使用A＆amp; b对于标准，然后列D和E应该自动算力。
我以前使用了带有索引/if/if/if/sode/match的arrayformula（在Cell C15中的示例），但这只能以最大的变化返回员工，并且无法通过标准区分。
提前致谢！
In Google Sheets, I need to find out which employee works more than 50% of the hours for a given shift at a given location based on timecard data (Table in col G:J). In the attached google sheet I need a formula in Column C that returns the name of the matching employee useing Column A & B for criteria, then column D and E should auto calcuate.
https://docs.google.com/spreadsheets/d/1HE90e1hVvsEIiFbNdb3sQ042LHMZhxyCno72eZMA79k/edit?usp=sharing
I was previously using an ArrayFormula with INDEX/IF/MODE/MATCH (example in cell C15) but that could only return the employee with the most shifts and was not able to differentiate by criteria.
Thanks in Advance!
发布评论
评论（1）
删除C2：D7中的所有内容并在C2：
delete everything in C2:D7 and use this in C2: