manager

  1. B

    fix my index match please

    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 -...
  2. I

    Count if /Count ifs help

    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...
  3. D

    Look up - while loop

    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...
  4. D

    Quickest way to change reference value of a Named Range (without opening the Name Manager box?)

    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...
  5. B

    help with creating an overview of the data in a table

    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 -...
  6. M

    send email throw excel

    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...
  7. D

    Excel keeps creating a hidden _xlfn.IFERROR name - why?

    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...
  8. G

    obtaining the cell values for Row and Column Refereces

    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...
  9. M

    VBA to copy and move data based on multiple criteria to new sheet

    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...
  10. H

    updating Scenario Manager Automatically

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

    Function to return a string

    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...
  12. J

    Extract values, ignore blanks and sort by count, based on name selected from drop down

    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...
  13. E

    Compare data in table with Exchange data

    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...
  14. T

    VBA - If contents of cell on different sheet don't appear in column, add to first available row

    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...
  15. G

    Indirect (Substitute) - limit on references?

    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...
  16. R

    Emails from Excel (via VBA)

    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...
  17. R

    Replicating OR criteria with Slicer

    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...
  18. E

    conditional formatting

    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...
  19. E

    Conditional Formatting and Formula

    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...
  20. R

    Name Manager does not open

    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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top