admin管理员组

文章数量:1344095

I had a formula made by @rockinfreakshow to fill background colour in cells depending on minutes added after a teacher's name but something happened and extra cell is coloured.

45 means 45 min so it should be only 2 cells coloured in green.

Here is the formula.

=index(let(Σ,xlookup(1,--regexmatch(B$2:B2," \d+$"),B$2:B2,,,-1),xmatch(cell("address",B2),address(row(Σ)+sequence(choosecols(split(Σ," "),-1)/15,1,0),column(Σ)))))

本文标签： Formula fix for Google SheetStack Overflow

版权声明：本文标题：Formula fix for Google Sheet - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1743735298a2529897.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。