department

I have a list of employees with their names and corresponding departments, and their annual bonus amount. I need to find all matches by department, and return employee name and the bonus. There may be multiple matches per department. If the department number to lookup is in D1, the...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:RelyOnVML/> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi all, I would be greatly appreciate to provide me support for a VBA code so that to run through row “1” and where find the words “Count” & “Total” should clear...

I am building our 2018 corporate budget and have 1 summary worksheet and 9 department worksheets that have the account number in the first column and January through December across the top row. I want to add up all of the department expenses in the summary worksheet for each month by account...

Hi Guys! I've created a spreadsheet that looks at a raw data set and runs a 'countif' based on the department name to return the numbers of cases assigned to that department, and the number of cases that belong to each cohort, as below. Unit 0-1 month...

Hi, I have a sheet that I am creating that has department numbers in column C and names in column B what I would like to do is have a macro to sort the data in columns B:DL by department number then by name but after each department add an extra line in so that they are spaced out. Can anyone...

Hi All, I have data in B1:BC102 In Column B there are department tags. From Column C thru BC there are department sales for each week number. I want to be able to select a department from a drop down and also select two week numbers and then to return the sum of the sales for that department...

Hi, All... I hope this is the right place to ask this question. If not, let me know... Our company recently upgraded to O365 (Office2017) and since then, whenever I close out of MS Word, it asks me if I want to save the changes to TestDirector7. I have always just clicked no to not save, but...

I've been asked to provide a summary of payroll by department. I have timesheets (workbooks) for each employee, and a summary workbook that looks up data in each of those workbooks. Each worksheet in the Summary workbook is titled as the date of the pay period, and each employee's name is listed...

Hi, I'm working on a spreadsheet that we use to record Supervisor safety contacts (when Supervisors have a "safety moment" with an employee). The contacts fall into different categories/topics (ie: PPE, egonomics, etc.). Each department (packaging, production, etc.) has a different list of...

Hello, I am trying to figure out if there's a way to use VBA to find subtotals based on two criteria. The data is already sorted by these two criteria (line number and department number) and I'd like to be able to draw a bottom border across the cells and put the subtotal on the last cell that...

I'm sure this has been addressed before on theses boards but I figured I would try asking before searching. I work at a small children's hospital with limited resources and we need to come up with a simple inventory system. This is what I want. Another department calls for a bottle of...

=LOOKUP(10^9,--MID(J43,MIN(FIND({0,1,2,3,4,5,6,7,8,9},J43&"0123456789")),{1,2,3,4,5,6,7,8})) Here is the formula, I am confused about the 10^9 and the -- that are listed in the formula. Can someone break it down and explain the meaning behind the inputs please? Thank you...

Hi Im new to VBA. I have a question below it would helpful if i got the answer <tbody> Department Sub_ID ID 8585 00_A01 00_A 9585 01_B20 01_B 1010 00_C50 00_C 2025 05_P20 05_P </tbody> I have the above table for data.I want function/sub to search and get/return the value in Sub_Id...

Hi guys! I need some help regarding an issue that I was not able to solve. I tried to figure it out but without reaching my goal. This is what I have: In sheet 1 I have estimated active customers for a period of time, where columns are months and rows are departments/states: <tbody> Month 1...

Hi All, I am trying to create a report in excel that has one sheet that ranks criteria from largest to smallest, by referencing a second sheet that stores all the data. One one sheet I have a list of departments, and their corresponding success rates as a percentage. The current order of the...

Hi everyone! I'm trying to figure out how to perform this but haven't been able to do it, so I'm turning to you since I believe you'd be able to help me with this issue. In sheet 1 I have estimated active customers for a period of time, where columns are months and rows are departments/states...

I have a project I am working on for my class and I am having trouble with this question. Below I am posting the actual question, the worksheet with the database, and the worksheet where I will be placing the macro button that will bring up the input box for the user to input information. What I...

I have the following formula: =SUM(SUMIFS(TSB!$I$5:$I$91,TSB!$J$5:$J$91,{"MA","MI","EQ"},TSB!$U$5:TSB!$U$91,"=MAR")) It works perfectly. MA, MI and EQ are Cost Codes, there could be up to 6. MAR is the Department. There are over 50 rows, each a unique combination of Cost Codes and Departments. I...

I use the attached roster everyday. Several times a week i have to break it down by departments. However all the depts starting with 3 goes on one, 4 on another etc etc. How can i easily make excel do this? My department number are all in the same column.

Hi all, I've created a spreadsheet for our company's credit card expense reports that has dependent data lists for showing valid account numbers based on the home department of the employee for whom the report is being completed. The workbook worked great until I revised it this year adding a...