manager

  1. P

    Populating Manager IDs? Vlookup?

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

    Pull info from First Column with Data

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

    Find duplicate in row based on cell value.

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

    Macro to help me transpose this information?

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

    VLookup on 3 Columns Formulae

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

    Name Manager

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

    lookup logic to interrogate specific exceptions - part 2

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

    Searching Field for Contents of Named Range

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

    Name manager question regarding new entries but not by the owner

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

    Table question please

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

    Name Manager Question

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

    Name Manager

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

    VBA Loop Copy & Vertical Paste 2 data points based on [3rd] Criteria

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

    I'm might be hoping for too much but....

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

    shortcut for changing formulas?

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

    Entire workbook grayed out

    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...
  17. John Caines

    no blank cell in drop down list - dat validation?

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

    No of People under each Manager

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

    Alternative formula to a multiple Index used in a 50,000 row table

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

    Headcount under Manager

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

Some videos you may like

This Week's Hot Topics

Top