Formula fix for Google Sheet - Stack Overflow

I had a formula made by @rockinfreakshow to fill background colour in cells depending on minutes added

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(Σ)))))

发布者:admin,转转请注明出处:http://www.yc00.com/questions/1743735298a4498147.html

相关推荐

  • Formula fix for Google Sheet - Stack Overflow

    I had a formula made by @rockinfreakshow to fill background colour in cells depending on minutes added

    6天前
    10

发表回复

评论列表(0条)

  • 暂无评论

联系我们

400-800-8888

在线咨询: QQ交谈

邮件:admin@example.com

工作时间:周一至周五,9:30-18:30,节假日休息

关注微信