I have a similar problem to one I had recently. But this one is quite a bit beyond my abilities. It's best to see the picture to see my problem.
I am trying to count unique numbers on a list, with particular conditions. I have a list of names of doctors who operate in either "strategic" or "tactical" mode. I want to assign them permanently to either of the two options (strategic/tactical), based on roles they've held in the past.
If they've ever been in strategic mode, I want the cell to return "strategic" while if they've only ever been in "tactical" mode, I want the cell to return "tactical".
If they've ever been in both, then they are assigned to "strategic".
Please see the attached picture. Please help. I really don't understand this clearly. I thought I was a super user. Not even close. Thank you to anyone who can help me with this.
Here is a picture of what is going on - you can see the challenge I'm facing. It's a lot more complicated this time around