manager

S14 has formula =INDEX(CTC!$C$57:$Y$71,MATCH(S$13,CTC!$E$57:$Y$57,0),MATCH($E14,CTC!$C$58:$C$71,0)) I want it to return the value 21,348 from cell E58 but I have messed up somehow, can you help please Excel 2013/2016ES13DescriptionMonth 1 ongoing14Division Manager - Faade-15Technician -...

Hi Guys I have the below data , i am trying to do a formula that would count the number of "open" status the Manager "roy" has. i tried a countifs but could get it right can any one provide any help? <tbody> A B C D 1 name manager id status 2 james roy 1 open 3 jack roy 1 closed 4...

Hi all, I have a list of of employees with a unique number assigned to each one. Then i have a separate list with the entire list of employees and their 1Up manager as well as their 2 Up manager. I need a script that will look up that employee on the list, finds their 1 UP manager, checks...

I often want to change what cell range a Name refers to, and want to know quickest way to do so. Currently, I open the Name Manager (which i can do w/ Alt+3, b/c i put it on the Quick Access Toolbar), but my file has several hundred names and scrolling through to find what I want to change is...

Hi I have an excel sheet that I use to track Manager development across my business. Currently I have a Data entry sheet that has the below columns (There are ten phases so 1 to 10, plus the info before to allow me to filter) Regional Manager - First Name - Last Name - Job Role - Location -...

dear Gents , I have a query if their is any one can help me , i have an excel file separated to sheets depend on the manager name each sheet contain information for employees these employees , in the informations i have the email for the manager my question how i can send email to the...

There's a handful of hidden names in my workbook that are killing my attempt to use VBA to copy 200+ Named Ranges to a new workbook. One of them is named "_xlfn.IFERROR" -- it doesn't show up in Excel's native Name Manager, but the Name Manager 4.3 add-in DOES show it (b/c it has the ability to...

I have this formula =SUMIFS('Staff Manager DL'!$Q:$Q,'Staff Manager DL'!$L:$L,******,'Staff Manager DL'!$N:$N,'Working Patterns'!I3,'Staff Manager DL'!$J:$J,'Working Patterns'!K$1)) Where there is ****** I need to obtain this information from 2 different cells. I have the Column Ref in K2...

Hello, I have a large data set that changes often. I need to parse out by manager and administrator. There are 27 possible combinations. I am hoping to move the data, including the headers, for each manger/administrator combination to a separate tab named for that combination. So in the main...

I would like to know how to update the Scenario Manager automatically when the data changes

Hello all, I am trying to write a function that returns a manager’s name based on the name in a column. So if column F has “John Doe” or “Jane Doe” it will return a different value based on who their manager is. But I keep getting a blank return when I enter the info. Can someone please see what...

Hello, and thanks for clicking into my posting. I am hoping that someone can offer some guidance with what I am trying to achieve. I am admittedly an excel novice, so I am having a difficult time finding a solution. The sample data below (beginning from column C) is pulled into a workbook...

Hi all, Apologies for just dropping in to ask a question but I'm not a programmer by trade and my knowledge of the fundamentals clearly isn't good enough! So I've got a table with the correct line manager for each person but the data that sits on the Exchange server is incorrect. I'm...

Hi, I'm looking to find some code for a spread sheet I'm building. Basically, Worksheet 1 is my data page which pulls from SharePoint. In Column D starting in Row 2, will be the "Team Manager" of an advisor. In Worksheet 2, I'm going to have list of all Team Managers in Column A, with...

Hello all. I am using the formula =INDIRECT(SUBSTITUTE($B$10, " ", "_")) to pull a list of advisors based on the manager name that appears in a dropdown cell(B10). The list is on a separate sheet in the same workbook. The manager names are listed horizontally and the advisors under them are...

Hi Need your assistance on this I have the following table and I am trying to - automatically send an email via Excel based on the Status (Column 5) to the Travel Asst. (Column 22, as 1st notification point) and Travel Manager (Column 23, as escalation) - in the escalation, copy the Travel...

I have a series of Columns containing employee names from my company directory. Column A is the Requestor of the respective row's project (several more columns containing project info). Columns B-D contain the next three managers in the org chart. <tbody> Requestor Manager Manager's Manager...

Hello, I have data in two tables, and I need to apply conditional formatting where the data matches and where it differs. For example: if I have a business that has 2 general managers and 3 assistant managers (table 1 - this data will change), and they should have 1 general manager and 5...

Hello, I have data in two tables, and I need to apply conditional formatting where the data matches and where it differs. For example: if I have a business that has 2 general managers and 3 assistant managers (table 1 - this data will change), and they should have 1 general manager and 5...

In an Excel 2013 workbook when attempting to open Name Manager (Formulas > Name Manger) I receive the progress circle for a few seconds than nothing. I have searched the forum and internet with to luck. Anyone have ideas? Thanks Ron