Getting Count Of People In Department With Score

Jun 13, 2014

See attached.PMS 2.xlsx. I have a table with data on PMS sheet and would like to have something like the example on the Example sheet using data from the PMS sheet.

View 2 Replies


ADVERTISEMENT

Count Department Names And Give Me A Total For The Returns For Each Department

Mar 9, 2009

I am producing a spreadsheet that will track returned defects. Column B is where I input the department variable. In a new table on the same sheet I need a formula that will count department names and give me a total for the returns for each department.

View 6 Replies View Related

Pivot Table Count / Sum Threshold Of Each Resource Within Department

Mar 25, 2014

Resouce Capacity Management .xlsx

How do I make my Pivot Table count/Sum the Threshold of each resource within department is within our 80% to 120% threshold?

View 1 Replies View Related

Count The Number Of People Under Each Class

Jul 4, 2008

I want to do is to count the number of people under each class, eg. 2300 - primary, 3 ppl, but i gt many many classes in my spreadsheet, do u all have solution for me using VBA

SAMPLE DATA:

2300 - primary
amy
ben
alex

1234 - secondary
Linda
tom
Jerry
Tricia
Mabel

5603 - advanced
Linda
tom
Jerry
Kevin
Calvin

View 9 Replies View Related

Count The Number Of People Per Classification Between Two Dates

Apr 21, 2014

Count people per their classification between two dates. Spreadsheet attached.

The answer I need to show in column (S) is:
Cell (S4) = 1 (supervisor)
Cell (S24) = 1 (fitter)
Cell (S36) = 3 (rigger)
j906 count.xlsx

View 1 Replies View Related

Formula To Work Out Score Based On Score System

Aug 10, 2009

I want to see if i can make a formula that works out how a player got a score based on a scoring system. See the attached file for more details. I want this to show that the player scored or didn't score, played a full match or was a substitute, was booked or wasn't booked and was sent off or wasn't sent off.

View 5 Replies View Related

Sum Values Based On Department.

Jan 29, 2010

From the example data of my previous post i would like to continue further to sum all the amounts based on department.My requirement is to sum the amounts in the next column down the department column. i had splitted the actual data into two categories based on departments "CNN" & "CNN-IN".

I had many departments like this in my data which i want to display them in different categories based on departments and the sum of the amounts in the next below cell of department. i got an idea on this that solution can be achieved if i apply Filters & Auto filter.But i m not perfect with the code and syntax.

View 4 Replies View Related

Calculating Average Days Overdue Per Department?

Jan 20, 2014

I have a file that's almost 3000 rows of data I have attached a test file for the purpose of this request. I am trying to figure out the average days overdue per department whose due dates have not already passed.test (1).xlsx

View 2 Replies View Related

Extracting And Calculating Types Of Leave Per Department

Nov 24, 2009

to calculate how many days of each different leave type have been taken for each Cost Code within an Excel 2003 spreadsheet. What adds to the problem is that the data extracted from our system comes to +/- than 50 000 lines. So doing this manually is out of the question.

I have attached a spreadsheet containing an extract of the information (DATA Tab) to better understand. Under the Summary Tab I have the format in which the information must be presented. For each Cost Code/Department I need to calculate how many e.g. Annual Leave/Sick Leave/Other Leave etc. was processed for each month from January to end of October.

Has anyone dealt with something similar? I would really appreciate any assistance as this problem is way above my Excel skills (not that it’s actually above average in any case... ;-)

View 9 Replies View Related

Hide Rows With Calculated Value Of 0 When New Department Is Selected

Jul 29, 2014

I have multiple departments and on each department we report the costs in four columns this month, budget, last month and last year. I have summed across the row to a hidden column and if the value is 0 I have a basic macro that "hides" the zero value rows. I understand I could further automate the process by having an "event" based in the spreadsheet which when the calculated values change the macro will run. This would mean when looking at the next department the zeros would automatically be hidden. I suspect I need a worksheet_calculate event but not been able to make it work.

View 2 Replies View Related

Nested Countif Not Working: Track Metrics For A QC Department

Nov 26, 2008

I am trying to track metrics for a QC dept. Right now my sheet has 35 lines of data and a header row, for 36 lines total. This is my funtion that isn't quite right:

View 2 Replies View Related

User Login To Excel And Edit Their Department Entries

Aug 5, 2012

I have a workbook that has a list of different depts. I need to design a way to enter a login of sorts to the excel and allow the user of that department to edit their entries only and lock the rest of the entries for the rest of the departments and do not show them in the result list after the user logs in. Once all department manager fills in his/her entries, the administrator is notified via email.

View 1 Replies View Related

Excel 2003 :: Get Number Of Items Against Specific Department?

Sep 7, 2012

I'm trying to get the number of items against a specific department which are contained in a sheet called "data", the sheet is contained in the same workbook.

There are named ranges for
Department (text)
Date_From & Date_To (in the format dd/mm/yyyy)
Band (Numeric 1 to 3)
Items (Numeric)

Using the following formula I get an #NUM error (using Excel2003)

=SUMPRODUCT(--(Department=A7),--(Date_From>=$B$2),--(Date_To

View 9 Replies View Related

Timesheet: Send Out A Mail Template Everyweek To All The Department

May 23, 2006

I send out a mail template everyweek to all the dept. employees using outlook. I attach a excel sheet to the mail so the employees can type in their hours and then sent it back. Then i go in manually each sheet and copy the info in THE timesheet excel sheet and sent it to the HR. Any easy way automate this process? What id like is to send a mai lcontaining the excel sheet, the emlpoyees fill it and the data tranfers to a excel sheet...

View 2 Replies View Related

If Statement (2 Conditions): Cardboard Manufacturing Plant In The Q.A Department

Jan 29, 2007

I work at a cardboard manufacturing plant in the Q.A Department. Occasionally paper claims need to be raised due to the paper being faulty (out of spec.). I have attached a spreadsheet which at present works out the paper cost according to which paper grade is typed into a particular columb. But, paper price varies according to the width (i.e. Deckle) of the paper as well. And this is the variable which I have not been able to implement thus far.

The relevant columbs are 'D', 'E' & 'I' for the purposes of this formula... It should be noted that below this I have pasted in the paper pricing list... and that in general each paper grade has 3 different prices depending on the Deckle (i.e. paper width), so there are 3 possible prices which can be displayed depending on the Deckle inputted into columb 'E'.

View 2 Replies View Related

Data Analysis Of Dates, Splits & Segments Of Department Codes

Jun 22, 2009

I'm trying to analyse data and summarise it by date (greater than 60 days, and between 30 days and 60 days), by department using the first two digits of department codes, and where there are multi-line order numbers.

View 4 Replies View Related

Excel Petty Cash - Department And Nominal Code Separator?

May 22, 2014

I have a petty cash sheet set up:

A1 - Date
B1 - Receipt No.
C1 - DEPT CODE
D1 - NOMINAL CODE
E1 - Reason
F1 - Amount
G1 - Running total (I've put a little formula in there to keep the balance - clever eh!)

So - this is fine - except I have to add the total amount for each department/nominal code each month.

What I'm doing at the moment is copying and pasting, sorting the sheet by:

Department
Nominal Code
Date

Then doing a manual add up of each and adding it to my month end report.

I'm really not an expert at all - but I thought there must be an easier way for me to do it. After inputting the petty cash there MUST be a way that it can automatically calculate it?

Or is this going to be a difficult thing to do requiring expertise in pivot tables etc?

View 2 Replies View Related

Formula Return The Number Of Asset Breaks For Each Head Of Department In Sheet3

Jun 30, 2009

I have the following formula which returns the number of asset breaks for each head of dept in sheet3 based on their teams in Sheet1 and then does a countif in >30_DAYS_ASSET in sheet2. In sheet 1 is a mapping table with range names "Teams2", "Teams" & "Managers". I now need the formula to also do a count on the unique numbers in sheet2 Column B, if there are duplicate numbers then that will be 1 asset break, so for example for for Joe plummer we can see there are duplicate case numbers so the formula in total should return 2.

=SUMPRODUCT(--ISNUMBER(MATCH(Teams2,INDEX(Teams,MATCH(C11,Managers,0),0),0)),
COUNTIF('>30_DAYS_ASSET'!$B:$B,Teams2))
Sheet1

AB2ManagersTeams3JOE BLOGGSAMP14JOE PLUMMEREQADMIN567Teams28SECADMIN9AMP1

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

Sheet3

AB4Head of DeptASSETS5JOE BLOGGS286JOE PLUMMER3

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

Sheet2

AB6SourceCase No.7SECADMIN4498618SECADMIN4498619SECADMIN44991310AMP144986211AMP144918012AMP1550935

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

View 9 Replies View Related

Deleting People's Second Name

Sep 16, 2009

In column G of my excel 2003 worksheet named: Data, I have a list of people's first names. These names were extracted from an external database.

Some of the first names actually contain peoples second names or partner's names.

Example:

John & Jill
James and Sue
Kerrie-Anne

Joanna Lyn

I need a macro to please delete people's second name.

So in the example above I need to keep all names that are joined by: & or and or - (such as John & Jill, James and Sue, Kerrie-Anne).

Also, in the example above I need to delete all names that are joined by a <space> (such as Joanna Lyn).

View 11 Replies View Related

My Macro Won't Run For Other People

Feb 10, 2010

It runs fine for me, but when others (who are using Excel 2003) try to run it, it won't fire. The second macro entitled "Delete Foothill" runs fine though. "Run Foothill won't fire.

Sub Run_Foothill()
Sheets("Foothill Plaza (Weekly Call)").Unprotect Password:="Foothill"
'
' Run_Foothill Macro
'
'
Sheets("OC").Select
Range("B37:C44").Select
Selection.Copy
Sheets("Foothill Plaza (Weekly Call)").Select
Range("B4").Select
ActiveSheet.Paste
Range("A12").Select
Application.CutCopyMode = False
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
Selection.Borders(xlEdgeLeft).LineStyle = xlNone
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With

View 9 Replies View Related

List Of People In Column A And In B To E There Are 4 Numbers From 1 To 13

Mar 14, 2008

I have a list of people in column A and in B to E there are 4 numbers from 1 to 13. (Each person has 4 different numbers). In the next 24 columns are concatenations of these numbers in every order possible. On a separate sheet I have a list of concatenations of all possible combinations of numers 1 to 13 in groups of 4. e.g. 1234, 1235 etc. I have then counted how many times each of the concatnations from the first sheet appear. What I want to do is put the names of the people whoes concatentaions match the ones on the third sheet.

View 14 Replies View Related

Create A Document To Be Available To Sevaral People

Oct 10, 2008

I am trying to do is create a document that will be available to sevaral people. The document will be edited by each person as needed. The completed document will then be used to order materials and supplies. What I want to hapen is each time the document is edited an alert is sent to the person responsible for the purchasing. I'm sure this is possible I just don't know how to do it.

View 14 Replies View Related

Filter Out How Many People Have Voted 2 Times Or 3

Sep 20, 2009

I have 3 spreadsheets I combined into one,

They are voters for 3 separate occasions. I would like to filter out how many people have voted 2 times or 3. I have sorted the information with 2 columns "LASTNAME" and "FIRSTNAME"

Example:
LASTNAME FIRSTNAME
ABBOTTJANET
ABBOTTSTUART
ABBOTTJANET
ABBOTTSTUART
ABBOTTJANET
ABBOTTSTUART

These first 3 show up 3 times, so I would like to take all the info from row one and two to get all the info for Janet and Stu,

View 2 Replies View Related

Email To Multiple People In A Sheet?

Dec 25, 2012

I have a sheet in which it is separated by zone area, name (about 200 names), and email. I am trying to add people to an email based on zone. For instance:

Nevada Billy Billy@gmail.com
California Sal Theemail@gmail.com
New York Jim Jim@gmail.com
Nevada JOe Joe@gmail.com
Arizona Alex Alex@gmail.com

So how can add all the people in X zone to a single outlook email (in this case Billy and Joe)?

View 3 Replies View Related

Create Monthly Rota For Up To 8 People?

Aug 3, 2014

I want to create a monthly rota for 8 people to cover monday to friday. Only one person per day and I need to put this in a calendar .

View 2 Replies View Related

Find The First And Last Names Of People In A Cell

May 18, 2009

I am trying to find the first and last names of people in a cell. I have a userform to get their first and last names separately. I am trying to run a VBA macro to determine if each cell in a column contains both first and last names, and then put a "Y" in an adjacent column. The Code I have is as follows:

View 5 Replies View Related

Send Mail To Filtered People?

Feb 5, 2012

I have an excel workbook which is a result of a sports survey I conducted. It basically shows who likes which sport, what level they're at, preferred time of play, etc, and their email address.

A colleague has created a type of form (using formulas, not VBA) wherein you select your criteria (Sport, Gender, Level etc) and it displays the matching names.

What I'd like is to be able to select, via a check box or similar, 1 or more names from the list of results for that sport, click a button, and their addresses automatically open in a new Outlook mail window for the person to send a mail to those people.

View 4 Replies View Related

Password Protection - Different Access For Different People

Dec 19, 2006

how can you set up a workbook to display different sheets for different users depending upon what password they input to open the workbook? The manager should see all sheets but employees only data entry sheets.

View 9 Replies View Related

350 People Tracking 24 Dates For Classes Each

Feb 20, 2009

I have a spreadsheet with ~350 people tracking 24 dates for classes each. On a seperate tab I have a macro that copies and pastes a pre-defined macro to display the due dates. My question is, can I have a macro run the calculation and put the result in the cell rather than have around 8,400 calculations on a sheet?

View 9 Replies View Related

Track The Number Of People From Each Zip Code

Jun 28, 2009

I have a workbook with a sheet for each day of the month where guest information is entered. There is a column for each item. There is a summary sheet that summarizes the number of members, guests etc. One thing I would like to track is the number of people from ech zip code.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved