Fam ID Has Doctor? Split Family?
119501322 Yes
142684606 Yes
142684606 No
142684606 Yes
196721887 Yes
548824945 No
550817217 No
238652523 No
555132345 No
I'm trying to figure out a formula that would return "Yes", or some other indicator, in the "Split Family?" column if rows with the same Family ID have different entries in the "Has Doctor" column. For instance, rows 2, 3, and 4 in the above example would return "Yes". I'm not sure where to start with this or if a formula is more appropriate vs code. Any help would be appreciated.
Bookmarks