Please refer to the document: http://1drv.ms/1H3Ntk2
请参阅文档:http://1drv.ms/1H3Ntk2
I am trying to figure out who is not scheduled for each week, in col F. The list of Staff members are in Col H. My data goes up to 52 weeks.
我试图找出每周没有安排的人,在F组。工作人员名单在Col H.我的数据长达52周。
1 个解决方案
#1
Supposing that you have the following:
假设您有以下内容:
Put this formula in F2 and press ctrl+shift+enter to calculate the formula; and then copy and fill down until the last row:
将此公式放入F2并按ctrl + shift + enter计算公式;然后复制并填写,直到最后一行:
=INDEX($H$2:$H$6,SMALL(IF(ISNA(MATCH($H$2:$H$6,B2:E2,0)),ROW($H$2:$H$6)-ROW($H$2)+1),1))
I hope it works. It is shorter than your own solution, at least.
我希望它有效。它至少比你自己的解决方案短。
#1
Supposing that you have the following:
假设您有以下内容:
Put this formula in F2 and press ctrl+shift+enter to calculate the formula; and then copy and fill down until the last row:
将此公式放入F2并按ctrl + shift + enter计算公式;然后复制并填写,直到最后一行:
=INDEX($H$2:$H$6,SMALL(IF(ISNA(MATCH($H$2:$H$6,B2:E2,0)),ROW($H$2:$H$6)-ROW($H$2)+1),1))
I hope it works. It is shorter than your own solution, at least.
我希望它有效。它至少比你自己的解决方案短。