departments

Hello, Please can you help me? I have one column, AH, with names of different departments of our organisation. Columns C,D and F contain health information as to whether or not clients are disabled. I want to count how many clients of 3 of our departments have either "No" entered into either...

Hi, I am trying to make a list based on the values in a table. In Row A I have a list of locations, in Column 1 I have a list of departments. Within the table I have various cells with "Pass" written in. I am looking for a way to list all the departments of each location that have "pass"...

I have this problem here: I have a list of 300 users of a site. Each user has one department (200 departments in total) and one region (AND, BRZ, PER, RDP). Each region has 50 departments. I made a speedometer that shows the % of access on the site by region. I used a combo box + INDEX...

Hi I have a column which has lets say 5 depts: hr, it, sales, marketing, and admin. If I want to see only hr dept. I apply filter and then select HR. What this called? Filtering all other departments except HR, OR filtering HR and leave other departments. Thank you very much.

Payroll items on the left, departments across the top: I want to group the FUTA, MED and SS into an "Employer Taxes" group and the other 3 payroll items into an "Insurance Premiums" group, but I can't! When I select more than one row label and right-click the option just isn't there...

I have a a number of workbooks that each have 19 tabs. I have a macro that goes through each tab and hides some blank rows. My current macro, as an example for one tab is as follows: Sheets("1000").Select ActiveSheet.Unprotect ActiveSheet.Range("$A$1:$A$700").AutoFilter Field:=1...

if column 1 has the names column 2 has the departments (either a or b) remaining column has the hours worked weekly how do you identify those with multiple entries (i.e worked in the 2 departments for a total number of hours overall in a week) ?

I am trying to combine multiple countifs and am not getting my desired amount. What I am trying to do is take multiple sets of criteria (departments) from the same column and then look at an additional column for a "YES" response and then divide all of those counts by a total count of all the...

Should be simple but I can't make it work. I have a tab with a large amount of data for 100 departments (all data relative on individual lines) In another tab I want to create a summary of several departments for a given column. Formula as it is now looks like...

Hello, I want to automate the process for creating weekly reports. In cell A1 I have a list of 10 departments in a dropdown menu. The rest of the calculations refer to that dropdown to return relevant performance information. Right now I select Dept 1 in the dropdown menu, save as PDF, select...

I have (simplified) 2 lookup tables (Requisitions and Departments) and a fact table (PurchaseOrders). I need to find who the requisitioners are for each department that created a PO for a particular vendor, with the Requesters field in the Requisitions table. Requisitions is linked to orders...

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