Forum Discussion
Solved
Searching multiple text strings in a range of text strings
Hi all, I've been working on this problem for a while and hoping all of your expertise will help. I get a list of "User IDs" and "Roles" those users have. I have to figure out which users are co...
mtarlerThank you very much for the thoughtful reply. I think that gets me very close to where I need to be. In your solution in Columns K-L, is it possible to see who they are covered by who has the most roles? I know my example data is not the best for this because "P111" and "H22" each have 4 roles, but in general, is it possible for count of roles to be involved?
I should have put that in my original post, sorry about that.