department

I have two tables, each with two columns: Table 1: Employee ID Number and Salary <colgroup><col><col></colgroup><tbody> ID Number Salary 41 36000 64 96000 153 40000 228 4000 252 72000...

Hello all, I got two comboboxes in my worksheet names cmbDepartment and cmbFilter. When a department is selected you can filter the department with cmbFilter. To fill cmbDepartment i filled in the ListFillRange. To populate cmbFilter i use the following code: Private Sub...

I have recently converted a project to use the Data Model and Power Pivots. This project has numerous Pivots on a template. The Pivots need to set the value of a PivotField to change the view between various departments. When I recorded the actions, I got a line that looks like this...

Hey everyone, Im trying to copmlie for a VBA code that will help me split my master excel workbook into multiple worksheets for each department.and its sub departments. Essentially, the master sheet is designed like <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit...

Hello, I need a formula to show the total number items sold each month by department then also count the total items sold by employee in that department. Please could you let me know what formula to use?

Hello I have build a model that predicts the progress of a multi-departmental project based on employees of the different departments. The model is quite complex as there are lots of interdependencies. What I want now to do is to find the optimum number of employees for each department. These...

I need to sum data for each department. This seems simple but my data's columns are not always in the same order. I'm sure there is a way to find the 'department column in an array then find the wages column and sum particular department names. It just needs to work with dynamic data. <tbody>...

Hi I have a spreadsheet with my staff listed across row 1. Row 2 contains their salaries and row 3 contains their department. I want to average the salaries of employees based on their department e.g. Alan Tom Helen 100 150 200 HR HR Admin I looking for a formula that would return...

Hi there I need some help with a formula I'm working with sheet A and Sheet B Sheet A has the following column headings Department (A7) Aug-17 (B7) Sep-17 (C7) Oct-17 (D7) Nov-17 (E7) Dec-17 (F7) etc. etc. Sheet B has the following data columns Department (A7) - data is A8 to A12,000...

I've been using Excel/VBA for years and I haven't ever come across something this frustrating. I have a formula (see below), that results in #N/A because the MATCH function fails. I have checked formatting, TRIM() for spaces, and a CHAR() by CHAR() breakdown as well as using =cell=cell and got...

Morning all I was wondering if anyone could help me with a formula. I need to create a lookup using 2 criteria (department in column A and department in row 4. All the departments are listed A5 to A50 and Months B4:L4. So the first one would be Finance is in cell A5 and January is B4 and so...

Hello Excel gurus, I am doing our employee database maintenance between our Payroll Database and NetSuite database. However, I am running into some issues that I need your expert help. The problem I have is our payroll database have employees (without middle name initial) and correct updated...

Hello. I have a system that generates reports and names the worksheets based on a numerical sequence xx-xxx (department number). I would like to add a report title in cell A3 with the department's name based on the worksheet name (department number). The code below works as long as all of the...

Hello, everyone I have three columns, F, AC and E. On column F I have the name of a Risk and on AC I have the department which have identified such risk. I'm trying to give a serial code to risks on colum E. Things to consider: - Each department can identify the same risk more than once. In...

Hello everyone, I have searched for this answer for an hour and a half now and have found threads treating this issue but all answers are customized to the specific question asker's needs and I can't figure out how to translate them to my needs. Here is my issue: I have a main sheet titled...

Guys, I have two sheets: Sheet "Riscos" where I have several rows with different risks and one range/column named "Departamento" (Department, in English). Each department can have several risks. Sheet "Riscos_formula_extraction" On Sheet Extraction, I want to extract data from sheet "Riscos"...

Hey, everyone, I need your help because I have on column A the name of the departments and on column B a specific number with regards to a specific risk. The thing is, each department can have multiples risks so I can have 10 lines for department A with different numbers on column B. On...

Hey, everyone, I just joined a company a couple of weeks ago and I realized that the department I'm working on has a lot of room for improvement. I don't want to get into details, but we deal with risk management. As we can imagine, we have excel files with hundreds of risks and KRIs that were...

Good Morning, I have been searching for a couple of days and cannot seem to find the answer for my question. It seems like most are looking to exclude nulls. I am in the process of meeting with 200 managers regarding their 90 departments, which is 85000 rows of data. What I am showing is...

I have two similarly formatted lists on different worksheets in the same workbook. List A is my master list. List B, which changes weekly, has some values that exist on List A along with completely new values. Each list has about 2,300 rows. I must compare these two lists and find the new...