roles

I have a rota with job roles as columns and a dates down the first column and initials in the cells displaying who is in what role that day. I would like to link this data to a worksheet that has this information as a Gantt chart - with roles down column A and dates long the columns with a bar...

I have a table, listing about 500 people that have been issued between 1 and 12 roles each. Each row of the table has a role. So, if Mr Smith has 12 roles, he will appear on 12 rows. I want to do a mail merge which would send one email to each person that lists their roles. I can't work out how...

Hello everyone, I have a spreadsheet "roles" Column A has user name Columns B:Z have their roles Example John Doe Display Edit Modify I export another spreadsheet from our ERP a list of user and roles but it is only two columns so John Doe Display John Doe Edit John Doe Delete So how do I...

Good Morning, I have a report I pull that has a basic data structure of the table below. I have masked and simplified the data. <tbody> ID Sub_ID User Role 1 A Person1 Supervisor 1 A Person2 Analyst 1 B Person3 Assistant 2 C Person4 Supervisor 2 C Person5 Analyst 2 C Person6...

hello, i want to compare a set of roles and rates with another set of role and rates however the rates might have different names like Account Director and Account Director (12) or account manager and acc manager as examples. is there a way to compare the data with 90% similar roles and then the...

Morning, Hoping to get some help on a piece of working I'm putting together. So: In Column R, I have a list of ROLES responsible for that ROW, IF > 1 they're on a new line. I am currently COUNTING them by using a hidden column with the following...

I have a workbook that has over 25,000 contacts that includes Name - Email - Phone Number - Location - City - Role. I am currently using a indirect list validation to sort between Location - City - However Roles are not filtered by City - they are filtered by location... This leaves roles...

30 people (Person 1, Person 2, ..., Person 30) 3 roles (Role A, Role B, Role C) 12 months I need to create 10 teams of 3 people to perform the 3 unique roles. The teams and roles will rotate per month for a year. Conditions: These teams will need to rotate randomly every month where...

Hello, Please help... I need to test a list of items against a set of rules as follows: List <tbody> User System Roles John Role 1 John Role 2 John Role 3 John Role 4 </tbody> Rules <tbody> Rule System Roles System Roles Rule 1 Role 1 Role 2 Rule 2 Role 3 Role 4...

I have column A blank in my employee roles sheet. When I enter their names in column A VLOOKUPS populate other columns with associated data. In the last column used (F) I need to display their pictures automatically. I have the employee pictures on another worksheet in the same workbook. These...

I need your help, MrExcel. I am using Excel2010. The workspace consists of specific roles that needs to be filled at all times by competent staff. There are more workers than roles, and the workers may be competent in more than 1 role each. For the sake of this example I'll cut the number of...