dept

Hello, I have a task to send mail to the person responsible based on the dept code with the part number. Each alphabet has a dept associated. For example letter "K" is a dept and the contact is example@gmail.com. The critical part is that all the letters are in a single cell. Need help...

Hi I am trying to create a spreadsheet to calculate debtor days using the count back method - but cant seem to get the correct answer. please see formula being used currently and data i am trying to work with: The formula i am using for the days is shown at the bottom - but is obviously not...

Hi I have a sheet with 20 graphs that gets its data from another sheet , Is there a way of changing the source sheet ie I have up to 10 sets of data on separate worksheets all with the same data just from different depts . What I would like is one set of graphs but be able to choose which...

Hi Guys, I'm using Excel 2016 and trying to retrieve some values from a table, here's a simple example; <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> Dept Sub Dept Sales Dept A Dept A1 100 Dept A Dept A2 150 Dept B Dept B1 500...

I'm trying to find a solution to an issue I have a user enter an employee numbers in column I and could be as many as 14500 rows..I have a drop down in column J which is just from data validation. I then autopulate columns K to T using a vlookup on the entries in column I The issue I have is...

I have a worksheet that I need to split it up into separate worksheets based on the dept name or number which are located in either column T (dept name) or column U (dept #). It's been a while since I have had to write a macro and I am struggling. Thanks

Hi I created pivot table like this <tbody> dept salary sales 10 admin 20 hr 30 </tbody> Then I inserted pivot chart - Pie chart. everything is fine so far. Now when I insert City as a column in the pivot table (see below) then the Pie chat wont work anymore. How can I fix the pivot...

Hello, I've been asked to help design a rota system but struggling with some of the more complicated formula's. I've provided a mock example but the formula required would need to search a row for the date specified, then search that dates column for the dept number and return the staff member...

Hi all I've been trying to work out how to get the results highlighted in red in this Sheet https://docs.google.com/spreadsheets/d/1GivPb-qhkexaGePD6sQor_y66N3TZbmX5in-jOz1olM/edit?usp=drivesdk Just trying to get John's Dept and sales results ordered by date. Not sure if it's an Index formula...

Sir Can you help me I have 7 columns In Excel (Rows A to G) with 100 rows of data Column F is used for Departments. Total 18 depts in Excel How do I write a function or macro in excel to to group the depts as follows: Dept A,B,C=Good, Dept D, K, N=Average, Dept M=Review & so on This Grouping...

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

Can someone tell me if there is a simple way to retain the original results of a formula when the source data is sorted? I have two sheets: an Organization List and an Organization Chart. The Chart is a visual representation of the hierarchy (who reports to who). If you can imagine some arrows...

Hello, I would like to get some help please. I am attempting to pull data for the sales team from a large data set using the following criteria; CNR over 90, probability of 100 and only names from the specialist column. As the department is placed under the specialist by default for unassigned...

Hi all I'm looking for a macro that will copy rows from a master work sheet where column "f" contains the same value as the worksheet name.. eg: i have 11 worksheets with dept code names and i want to copy row from a master worksheet where column "f" contains the dept code and then loop...

Hi, I have 2 workbooks one called "Overview" and one called "Dept 1". Each workbook has 12 sheets for the months of the year. What I want to do is in the "Overview" workbook sheet "January", reference a cell "N$32" in the "Dept 1" workbook sheet "January". I did this using the formula...