Or try this in E2 and copy down
Formula:
=--(OR(AND(OR(C2="MD",C2="DO"),LEFT(D2,3)<>"Dr."),AND(C2<>"",D2=A2)))
Or try this in E2 and copy down
Formula:
=--(OR(AND(OR(C2="MD",C2="DO"),LEFT(D2,3)<>"Dr."),AND(C2<>"",D2=A2)))
Neither of those worked for all contingencies, but they did help me find a solution of
=IF(AND(OR(C2="MD",C2="DO"),D2="Dr. "&A2),0,1)-IF(AND(OR(C2<>"MD",C2<>"DO"),D2=B2),1,0)+IF(AND(OR(C2="MD",C2="DO"),D2=B2),1,0)
Thank you so much for all your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks