department

I've got a table that is pulling data in from a query. It has work orders for six different departments on it. I use a large (and slow) macro with many ElseIf statements to determine which department each work order belongs to. I then use that cell in another macro that pastes the row into a...

Hello, I am struggling with a formula to create a sumif with a dynamic range. The data I have is as follows: <tbody> ROW/COLUMN A B C D E F G H I J K L M N 1 Department Expense Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 2 Finance Phone 199 90 10 7...

Hello, I have three columns, Department, Employee Name, and Contract Status. The data table is about 670 rows and will continue to grow. Thus, on a separate tab, I would like to extract the Department and Employee Name columns, but the rules are as follows: 1) Sort alphabetically...

Hi guys, See below, I have used the following formula intending to retrieve the red bits. =LOOKUP(MID(A2,3,2),$J$1:$K$5)&LEFT(C2,5)&"-"&D2&"_"&"PN_"&B2 instead, it Returns as: Finance_Department_43107-43287_PN_876789 I tried to Change the Format cells as Dates, it still won't work. oddly...

Hi, need to automize the description based 3 criteria. - Personnel number (#3 and #4 are letters short for department) - Personnel code (random) - Appointed period would like to have the description within such format: e.g:Finance_Department_01.01- 01.07.2012_PN_876789 (Indicated in red)...

Hi All I have 3 pivot tables that has the department name in the filter section, team names in the row section and scores in the values section I have created a slicer on the department name. Now here is my problem Each department has different number of teams. What i want to do is when i...

Hi all, Hopefully I can explain this well enough - I have a dashboard based off of tables on other sheets which can be filtered to show results for individual departments. I also have corresponding email addresses for each department that the filtered results need to be send to. Is there any...

Hello All, I need a formula... I have data like below.. <colgroup><col span="2"><col><col><col><col><col><col></colgroup><tbody> Name Department Q1 Q2 Q3 Q4 Q5 Q6 Howard IT 3 3 3 3 3 3 Gill HR 4 4 4 4 4 4 Rajesh REWS 4 4 4 4 4 4 Jones MI 4 4 4 4 4 4 Sorvino IT 5 5 5 5 5 5 Ravi...

I have a Workbook with 9 Sheets Each Sheet has 4 columns of data: Column A: Login (Time Stamp of User login) Column B: User (Name) Column C: Team (Department Name) Column D: Week (Week Name ie. Week 1) Each Sheet represents a department. Below is what is needed 1. Total Number of Logins...

Sheet1 contains the data <tbody> Department Position Name Extension </tbody> What I would like on sheet2 is Row 1 = 1 merged Column with Department Value Centered Row 2 = Column 1 Position, Column 2 Name, Column 3 Extension Repeat while Department Value is the same, when the Department...

An excelWorkbook has four sheets which are named Sheet1, HR, IT and Finance. Sheet1 has adrop down list in cell A1 which lists the names of the other three sheets whichare the company departments HR, IT and Finance. <o:p></o:p> I want theuser to open the Excel Workbook and at first only have...

Hello everyone! I am creating a workbook that will have a Data tab that will have all of the time-sheet data from all of the employees time-card punches. What I am wanting to do is click the Sort Employees button and have each employee copied from the Data tab and pasted to their respective...

I went to a Mr. Excel workshop a few months ago and told me that this board was a great resource. I know excel fairly well however my VBA skills are lacking. I did try to search the site and I found similar or related posts but I couldn’t find exactly what I needed. Any help is greatly...

Hello, Im lost with this. even my IT Department is having trouble. I have a list of parts. List 1 has single part number, description and total qty. well list 2 comes from another department and may have 1 part number with multiple delivery locations. My department would like to be able to use...

Hello, I want to replace only whole words in a cell Also, I do not want to use Replacement, I want something I can use with Arrays The function does a good job of finding only the whole words but is there a way to get it replace the whole word with the MatchExprValue Ex cell value =HUD...

Hello clever people... I need some help which I think would be easy to someone that can do VLookups. I have a list of all staff on sheet 1, which has columns that include their first name, surname, department, line manager. On a separate tab, I would like to be able to count how many direct...

Every week, I have to analyze ten workbooks like what I have attached. Right now, I have to manually add each category per job department so under job 606, I have to add all the amounts and hours worked for code HL1, then I have to add all amounts and hours for code REG, and so on. Is there...

Hello all, I am working on creating an executive dashboard. I need to sum the total spend for all budget codes by department and company. Unfortunately the department does not come through into the report but the budget codes does. There are at a minimum 20 budget codes per department. So I...

Hello all, I work for a food manufacturing business which still operates a largely paper based reporting system. At present the business is unwilling to invest in dedicated software so I am hoping to utilise excel in an attempt to reduce some process. At the moment, 4 departments hand write a...

Hi all, I am new to the forum and am hopeful that you learned excel types can help direct me to a solution. I am working a data sheet for our companies recruitment team. I have created 3 tables that are identically formatted with department column headers and month row labels. the 3 tables show...