Advertisement
Guest User

Untitled

a guest
Feb 20th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. =IF(COUNTIF([@PCP],"*"&[@Rendering]&"*")>0,"YES","")
  2.  
  3. Smith, John MD Brown, Bob MD
  4. Jones, Mike MD Green, Ann MD
  5. Doe, Jane MD White, Mary MD
  6.  
  7. Rendering PCP Seen PCP/team?
  8. ---------------------------------------------------------------
  9. Smith Smith, John MD YES
  10. Smith Jones, Mike MD YES
  11. Brown Smith, John MD
  12. Green Brown, Bob MD YES
  13. Doe White, Mary MD
  14. Doe Jones, Mike MD YES
  15.  
  16. =IF(@PCP = Smith AND @Rendering = Smith, "YES", IF(@PCP = Smith AND @Rendering = Jones, "YES", IF(@PCP = Smith AND @Rendering = Doe, "YES", IF(@PCP = Jones AND @Rendering = Jones, "YES", IF(@PCP = Jones AND @Rendering = Smith, "YES", IF(@PCP = Jones AND @Rendering = Doe, "YES", IF(@PCP = Doe AND @Rendering = Doe, "YES", IF(@PCP = Doe AND @Rendering = Smith, "YES", IF(@PCP = Doe AND @Rendering = Jones, "YES", "")))))))))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement