I have a spreadsheet of security permissions for one of our ERP applications. Of specific interest is a column B named "role", and column G "username". Each username can be assigned 1 or more security roles in our ERP application. What I need to do, is for any instances whereby users have a role called "read only", is the list any other roles they have also been assigned, (which they shouldn't have any, but there may be instances where they have been assigned read-only and then other roles too!). can anyone advise how this could be achieved. It is a huge report so doing it manually is not practical.