Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IF(
- And(
- NOT(ISBLANK(INDIRECT(ADDRESS(row(),column()-1))))
- ,RegExMatch(
- LOWER(INDIRECT(ADDRESS(1,MATCH(MAX(B2:D2),B2:D2, 0)+1)))
- ,INDIRECT(ADDRESS(row(),column()-1))
- )
- )
- ,"YES","NO")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement