Check and validate in column values wrt to fix value

[shivspatil]

Dear Gurus, in my first columns I have name list and column B has the roles. I have uniques of column A and I want to validate if the name has a specific role assigned in column B and should return response in column E. Have attached a file for your reference. Please help.


Shiva

[Pete_UK]

You can use this formula in E2~:

=IF(COUNTIFS(A:A,D2,B:B,"SCM"),"Yes","No")

then copy down.

Hope this helps.

Pete

[shivspatil]

Perfect Pete. Thanks a ton. Add Repute is removed now?

[Pete_UK]

You're welcome - glad to help.

No, the Add Reputation button is still there for me in the bottom left corner of all posts.

Pete

[Pete_UK]

I see you have found the button now, so thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete