manager

Hey all, I've got this list of Employee ID - Employee Name - MGR ID - Manager Name. 1400 employees, ~400 managers. I'm looking for a formula or function or feature - SOMETHING that will allow me to populate the Manager ID. I know VLOOKUP would work if it was a 1:1 relationship but as the...

I have a spreadsheet with Positions down the side and Steps across the top and the rates in the columns. I need a formula that will pull the rate for the first available step into one column. So for receptionist, it would pull the Step 1 rate, for Technician it would pull the Step 3 rate and...

I'm looking to highlight/identify duplicates in a row based on a common title (same) and am not sure of the direction to proceed. Simple example: There are two helpdesk title's and both are part of similar groups. I would like to identify all groups that "helpdesk" have in common. Then...

I searched for a similar situation to mine and didn't see one (apologies if one exists and I missed it!) I have to format a long list of managers and their employees for mass emails, and the lists I get from our database are: <tbody> Manager 1 Employee A Manager 2 Employee B Manager 2...

Good Morning Thanks for Reading I have two spreadsheets one called Switch Info and the other Database Master, I am looking from the Database Manager to the Switch Info Both Have three columns called Login (Column A), Device (Column B) and Numbers (Column C) First Formulae I need a lookup to...

Hi, I have a form on a tab in the spreadsheet that links to data on the first tab via VBA coding. I have updated the names of each column in the name manager part of formulas but 2 sections of the form aren't pulling the data through from the sheet like the rest of the form instead of populating...

Hello, If (Col B) Manager is equal to: Brian OR Mike OR Shawn then, using the grade field (Col A) output the corresponding average value associated in Sheet2 (Col D and E) If (Col B) Manager is equal to: Julie OR Sharon OR Liz then, using the grade field (Col A), output the corresponding...

I am using the following formula to check if a contact's job title, stored in cell K5, is found in a named range of job titles. SUMPRODUCT(--ISNUMBER(SEARCH(LeadershipTitles,K5)))>0 The problem is that this formula returns TRUE when the value in K5 is "Sales Coordinator" but that text (i.e...

Hi, Last week i went through all my names in the name manager & cleaned everything up as there was quite a few duplicates etc. Yesterday i added 3 new worksheets to my workbook GRASS G INCOME G EXPENSES I have just gone to the name manager and for some unknown reason i have say 20 new entries...

Good Morning, Ive tidied up all my table etc in the Name Manager but stuck on one. All my table are 1 column. So examples of my tables. Header Sold Name manager i see under refers to =Table22[SOLD] Range AK2:AK66 Header Bought Name manager i see under refers to =Table9[BOUGHT] Range T2:T100...

Afternoon, For some reason some of my drop downs stopped working. I am now cleaning up the named manager list & these are now starting to work correctly. In the page that opens up is there a way to click on a NAME as excel tell you on what sheet it is connected with. Name i say name this is the...

Hi, Is there a way to set up Name Manager to change the Name of the sets in Name Manager automatically so it will allow the drop down lists to continue to work? Thanks Angus

I have some data that I need to flip and copy & paste vertically based on the value at the intersection of a row & column. Below is the data as it is currently & how I need it to look. The result is based on where the policy is marked as 'Required' for that job & policy. I have tried various...

....thought I would ask anyway. i have 5 different workbooks (data added by team captains) that feed into one table combined by a power query (viewed by team manager). Captains add data to their table and the manager can see this when he refreshes his query. All is working well. Now, is...

Hello, Experts. Novice here. Seeking advice. I have a workbookcontaining many spreadsheets pertaining to data pulled from many locations/sites. This data is sorted by site as well as by the manager responsible for the site. And each manager has several sites. Each spreadsheet shows each...

I have a workbook with multiple worksheets. I was working in it a week ago and everything was fine. I opened it today and the entire workbook, including all of the menus, is grayed out. Where the cells would be is just a big gray blank, no borders, no cells, no numbers. Even in the File menu...

Hi All. I simply want to create a drop down list with data validation The list comes from a tab that is from name manager. It is A3-A7,,, the list being; NOT STARTED IN PROGRESS AWATING REPLY COMPLETED After the word COMPLETED is a cell with nothing in it. When I go to insert the list (via...

Hi Experts, Need your help to calculate number of people under each manager. Please help me the decode this complications. <tbody> Name Level Lead Manager Brian Level 1 Alfred Sheldon Erick Level 1 Alfred Sheldon Alfred Level 2 Sheldon Raymond Sheldon Level 3 Raymond Edward...

I am contacting the forum today in search of some advice/help or solution to a problem which I'm pretty sure is being caused by the size of the data I am using and what formulas I am trying to utilise within the sheet of data. In Column H of my report (this report is 50,000 rows long) is column...

Hi Experts, Need your help to calculate number of employees under manager. Is there a way to calculate it? Raw Data. <tbody> EMPLOYEE NAME REPORTING MANAGER FUNCTIONAL MANAGER Vinay Chonale Rohit Jahagirdar Sunil Bailakere Rohit Jahagirdar Sunil Bailakere Dhananjaya S Husain Mulani...