Figuring out user status

[skittlz]

Hi,

I have a tab that has user and their status in 1 tab of raw data, and a final status in another tab. The raw data has multiple entries for the user AND status. How do I match all the entries, and figure out the (final) user status? The user status can be Active, Inactive, or Decertified. Decertified would supersede Inactive, Inactive would supersede Active. See Screenshot below!

re

 

[skittlz]

I got it to work!! thank you etaf!!!!

 

[etaf]

you are welcome