Advertisement
enissay

Enissay

Aug 7th, 2014
252
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. =IF(
  2. And(
  3. NOT(ISBLANK(INDIRECT(ADDRESS(row(),column()-1))))
  4. ,RegExMatch(
  5. LOWER(INDIRECT(ADDRESS(1,MATCH(MAX(B2:D2),B2:D2, 0)+1)))
  6. ,INDIRECT(ADDRESS(row(),column()-1))
  7. )
  8. )
  9.  
  10. ,"YES","NO")
Advertisement
RAW Paste Data Copied
Advertisement