department

Hi All, I have data in two columns. In column A & and in column B. Column A contains customer name and column B contains department. We have total 3 departments. And a customer may belong to one department or it might belong to more than one department. I want to apply a formula in Column C to...

I need to know if what I'm wanting to do is even possible. I am trying to make a rotating schedule (4 weeks different schedules each week) for associates in multiple departments at my store. I want to have a data validation list that when I select Department 1 it will pull up all rows of...

Hello everyone, I need some big help on functions and formulas as I am completely stumped, and am going to get some tutoring to further my knowledge of excel, on account of me entering several different formulas, and not one being accurate. I have to create a formula in cell c5 that calculates...

Hi All, I have a table with a number of risks in it across 50+ departments. I have a formula which provides me with the top 5 risks (based on risk score) across the entire building as a whole, however, I want to adapt this so that when I change the department via a combo box with a Cell Link...

I have a dashboard that is created in Excel for many different departments, packaged as a PDF using the Ron de Bruin VBA and then emailed to them automatically via Outlook. At the bottom of the dashboard is a section called "Department actions." At present the only way for this to be returned...

I have a detail table that shows monthly salaries by month across the top and individual staff members with department down the side . I'm creating a summary table that counts the number of staff in a table by date across the top and department down the side (salary greater than zero). I've...

i have workbook that i received from my sister, it has alot of formulas with hardcoded text in them. for example =if(A2="Procurement Department Los Angeles Area", True, False) would it make any different in terms of speed if i put text Procurement Department Los Angeles Area in a cell lets...

Hello, I have a spreadsheet with multiple columns, where I created an IF statement to add the total values in the relevant cells and if the total = zero, I return the phrase "hide" These become the rows I want to hide until we updated values next period. This is for a department level P&L...

Good morning everyone, I have a difficult problem and I do not know how to solve it. I do not even know in which direction to go, what formulas I should use? Assumptions: 1. In the first step is planned the number of employees. It is planned for each employee which day he is in the plant and...

I intend to categorize Employees in 4 Groups with in a Department as shown below:-

Hello, I am a newbie! I would say my Excel knowledge stretches to "VBA beginner". I am trying to use VBA to get data from this format (on a tab called "Before"): <tbody> Post Salary Allowance NationalInsurance Pension Department 486 £90,998 £0 £12,558 £19,019 1 503 £99,020...

Hi there, I have a question about the IF Function in Excel 2007. I currently have a spreadsheet that's separated into categories, in specific by "Departments". Here's an example: [Column A] [1] Deparment=1209 [2] Food [3] Water [4] Clothes [5] Misc [6] Department=1211 [7] Housing [8]...