role

I have a group of 10 people doing 5 roles in a spreadsheet. I would like a cell to contain the five people NOT doing a role. So the formula would check the five cells, compare with a reference containing all ten initials, and list the initials of people not in a role.

Hi Guys, I've got a question about RLS in PowerBI. My problem: When i give someone access to my reports without a role, they see all data. Is it possible to set my dataset to like a RLS only? So when someone without a specific role opens the report, they see nothing. I ask this because of...

For instance, I have a whole range of job roles and the count, and I want to group several functions together, such as: Group 1 Sales Marketing Business BD Business Development Group 2 Admin Administrative Accounts how do I filter and group them together easily as long as the job role...

Hello, What I am looking for is vlookup type function that will look up the first 3 columns in data worksheet 1 and find it in the data lookup table and find the pay grade and if it is there return the Role Type to Data Sheet 1 Role Type. Data Worksheet 1 (8k rows) Division Name...

Hi guys, I'm new here and very new to VBA (just know the bare basics) -- nice to meet you! I wanted to create a code to insert a blank every 10th row and after copying and pasting bits and pieces of other people's codes, I finally got the code to work...but I'm not sure how this is working and...

Having a very annoying problem for users which does not happen to me. I run code when the workbook is opened that automatically connects to a SQL Server and brings back data for users depending on their role. The connections work without issue for me, but at times they throw errors for other...

Hi, I need some help to put the following data into an excel pivot so that I can look at any Oracle Role and see only those responsibilities that apply (ie where the X exists - I don't want to see any of blank cells_). Is there a way of doing this? A regular pivot does not seem to...

Hi There, We are trying to use excel in several ways. We have a survey that our staff fill out, a series of questions some are answered yes or no, some are answered on a scale from 1 to 5. The questions are different for each role. We currently have a workbook with a sheet for each role. The...

I have roles in column A and their corresponding entitlement in column B I need a macro to pick the child role corresponding parent role Role Entitlement Role 1 Entitlement 7 Role 1 Entitlement 8 Role 1 Entitlement 9 Role 2 Entitlement 7 Role 2 Entitlement 8 Role 3 Entitlement 6 Role 3...

Hi I have a table on one sheet with a few columns, including COUNTRY, AREA, ROLE and COST On another sheet I have the same columns where people can select the country, area, role from a drop down The sheet with the predetermined area is called called "CTC", some example cells: C7 = USA D7 =...

<tbody> A B C D E F G First Name Last Name Role Start Up Contact Unique + "Invested" <-- + "Acme Corp" George Aquino Invested Initech Justin Abad George Aquino ??? George Aquino Invested Acme Corporation Shaun Jai Femi Folami Alban Dushku Founded Massive Dynamic Sean Baako James Jones...

I am trying to auto-populate cells using IF/Then Statements (I think) The following is a description of the sample table below: - Hours (Number of Hours Worked) - Role Name - Role Code (LSEA, SEA1, SEA2, SEA3, Tools, PM, GOV) Question: How do I link the hours for a specific Role name to the...

So, I've been working on this for quite a while with no luck. All it's supposed to do is merge two files together. It works until I add a new parameter (location). I've tried several variations on the code with no luck. Do I have to add another VLOOKUP? 'Opening Source Files...

Hi I am trying to put some names into excel to create a histogram. I have everything inputted but I want the colours in the cells to change depending on the job role, i have a couple of rules but cannot seem to get the rule to do a formula that makes the colour change depending on the job role...

I have created an Org Chart, but due to the size of it I want to generate rollovers, so hover over a name and a larger personalised image appears with the individual's details - name, role, grade, email, tel etc. Is there a simple way to do this? TIA

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'm analysing some system role based permissions, to understand and display which users have access to which permissions and perform a comparison. The way the data has been presented to me so far is such that I have one table that presents permissions mapped into groups permission profiles...

Hi, I wanted to create a Hierarchy, which can contain multiple parent and child. Input Data :- <tbody> Role 1 2 3 4 5 6 7 8 9 A R R R R B R R R R R R C R R R R R R R D R R R R E R R R R R R R F R R R R R </tbody> Role A - 1,2,3,4 So each Role is formed with...

Hello, I have found a formula that returns distinct values excluding blanks, but I do not understand what the role of &"" is. The formula is: =IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B1, $A$2:$A$10&"") + IF($A$2:$A$10="",1,0), 0)), "") The formula returns the same results whether the...