Report & Summarize Counts
Sep 25, 2007
Refer to the attached sample workbook. I need to track daily tasks of our staff and then indicate these tasks on the "Activity Report" sheet.
Each task will have a code and I will indicate; by menas of the code, which activity was done by inserting that code in the time slot provided.
Once each day is completed; I need to tally up the amount of each activity that took place and it will be diplayed in the "Specific Activity Summary" section of the sheet.
Also; once the tally for each activity is completed, the amount of time spent on that activity will be indicated on the "Daily Activities Summary" sheet.
How do I go about linking the specific cells to be able to create this "tally" and "summary."
View 9 Replies
ADVERTISEMENT
Aug 28, 2006
It does everything I need it to do but I would like it to sort 3 columns and then merge the data. I have included a sample with a "WishReport" tab the shows what I am looking for. If possible (not imperative) I would like it to add a "unit cost" column and provide a grand total.
Option Explicit
Public Const SZ_INPUT As String = "SheetData"
Public Const SZ_OUTPUT As String = "Report"
Public Const I_FIRST As Integer = 0
Public Const I_LAST As Integer = 1
Public Const I_DATA As Integer = 2
Public Const ROW_HEADER As Long = 1
Public Const ROW_DATA As Long = 2
Public Const COL_FIRST As Integer = 1
Public Const COL_PROJECT As Integer = 2
Public Const COL_LAST As Integer = 5
Sub CombineProjectData()
Dim lInputRows(I_FIRST To I_DATA) As Long
Dim lFirstInstance As Long, lOutputRow As Long
Dim szData As String
Dim iCurrColumn As Integer
Call FindRowArray(lInputRows(), , COL_PROJECT)...............
View 5 Replies
View Related
Jul 1, 2012
i attached link to sample and its contains employee sheets and Report sheet ,and in Report sheet there is comment
[URL]
View 7 Replies
View Related
Aug 30, 2013
I have two worksheets in my report cards:
1) Data - the students are listed in Column A, math scores in Column B, reading scores in Column C and science scores in Column D. The grades of 300 students are entered in this sheet.
Student
Math
Reading
Science
Jimmy
75
84
100
[code].....
2) Report Card template - This is the report card that needs to be generated for each student. It's pulling the student name and grades from the Data worksheet.
Student Name
=Data!$A2
Math
=Data!$B2
Reading
=Data!$C2
Science
=Data!$D2
How do I create worksheets (report cards) for additional students? I have 300 students in the school. I need the next worksheet to reference Data!$A3. I know how to cut and paste the report card template and then edit =Data!A2 to be =Data!A3 to create a report card for Sally. How do I create the 300 report cards I need?
I've been teaching for 13 years. I can create a report card for each student in my class and edit each worksheet individually for each student. Now I've been asked to do this for the whole school and I don't know how to create the other 299 sheets I need.
View 1 Replies
View Related
Jul 2, 2008
How do you create a macro to copy the information from my weekly reports to a monthly report and be able to update automatically. If you had 4 worksheets (for each week of the month) and 1 mastersheet for the whole month in a workbook. All titles are the same and If you needed to copy all the data that is in the columns, say, A through I, starting with row 4 to however many rows are in a given week. The reports can be made up of numicerial values, text and dates. Let me know if more information is needed or an example worksheet.
View 4 Replies
View Related
Apr 12, 2009
find the attached Example file. I need to create a report either by using or without using VBA.
View 3 Replies
View Related
Jan 13, 2009
in sheet 2 cell g16 i need it to count how many times "horse racing" appears in sheet 1 column m and also for it to count how many "y" are in column g of sheet 1 and return something like
4 from 4
this example is taken from the attached sheet
basically it needs to count the yesses in column g that correspond to the horse racing in column n
so there could be 7 instances of horse racing ( 4 in this example ) and count the y's in column g which could be 2 ( 4 in this example ).
View 6 Replies
View Related
Dec 19, 2013
I have data over the last 170 days. Each entry has a time stamp. I would like to count how many entries there are between 7:45 am and 2:45pm. A total count across all 170 days is needed, but it would be great if I could break that down by calendar day (i do have that as a column).
Here is a sample of the data:Friday11/15/1307:08AM
Friday11/15/1307:08AM
Friday11/15/1307:16AM
Friday11/15/1307:16AM
Friday11/15/1307:46AM
Friday11/15/1307:46AM
And the sheet has dates starting in June and ending in mid December.
View 14 Replies
View Related
Nov 6, 2011
Basically I have the following (simplified to just include relevant columns
Text Code Location
FFF VAC 2400
FFF VAC 2100
FFF RGG 2400
FFF RGG 2100
BBB RGG 2400
BBB RGG 2100
BBB JAM 2400
BBB JAM 2100
FFF GOG 2400
FFF GOG 2100
There is also a pass/fail column.
I need a table which counts 12 separate stats
Passes and Fails of the following:
1: Number of GOG
2: Number of JAM
3: Number of 2400s not including 2400s already in 2 and 1
4: Number of 2100s not including those already in 2 and 1
5: Number of VAC and FFF in 3
6: Number of VAC and FFF in 4
1: I have done =SUMPRODUCT(--(=Code="GOG"),--(Pass/Fail="pass"))
2: =SUMPRODUCT(--(=Code="JAM"),--(Pass/Fail="pass"))
how to split the remaining stats instwead of having to filter manually every day
View 9 Replies
View Related
Oct 9, 2008
I want a macro that counts a column that is not empty,.i want it to put in a button.
and also i want to count the data that has empty match ....
View 9 Replies
View Related
Jul 6, 2009
I have an excel sheet (2007) with over 800 records. Column A is having some names which are repetitive and Column B with some relative prj names they are alos repetative. I need a macro which counts all the names and Prj having unique combination and put in the another sheet of same workbook. e.g.
Col A ColB
ABC PRJ1
XYZ PRJ2
ABC PRJ1
ABC PRJ6
XYZ PRJ2
ABC PRJ1
PQR PRJ3
ABC PRJ1
The result in new tab should be:
Col 1 (Header: Name) Col 2 (Header:Prj Name) Col 2 (Header:Count)
ABC PRJ1 4
ABC PRJ6 1
XYZ PRJ2 2
PQR PRJ3 1
View 9 Replies
View Related
Jul 18, 2009
I'm hoping there's a more efficient way to do this in that I'd like to replace - for example - over 100 formulas with just 1.
Take this simple example range in a column of numbers: 100 down to 0 and for each cell there's a count of how many times that number is greater than those that follow. The 1st is 100 times, the 2nd 99 times and so on... finally I need a sum of these resulting counts.
My current method would require over 100 formulas in 100 extra cells to do this
View 9 Replies
View Related
Aug 5, 2009
I have redudant data appearing as such.
ITEM_A
ITEM_A
ITEM_B
ITEM_A
ITEM_B
ITEM_C
I wish to create a formula which counts the duplicates in the order which they appear from top to bottom. Thus the example below would count the first instance of ITEM_A as "1", directly below it the second instance of ITEM_A would be counted as "2" as it already has appeared once. Ex:
ITEM_A 1
ITEM_A 2
ITEM_B 1
ITEM_A 3
ITEM_B 2
ITEM_C 1
View 9 Replies
View Related
Jun 13, 2006
I have a report I deal with each day. The report has Apples, Oranges, Bananas, etc.... Sometimes the report only has 1 of the 10 and sometimes the report has all 10. How would I count the rows in this range to see how many line items I have? Letting me know if it's 1 or 5 or 10?
View 7 Replies
View Related
Jul 1, 2006
I have a spreadsheet which I use to count the occurrences of a value against a range. Basically if the value is uppercase I count as 1 and for lowercase 0.5
This spreadsheet is used as a holiday chart and I have previously used the formula below however, for some reason it no longer works. Not even if I change the lookup value.
The exact function takes a single cell as its value but I have a spreadsheet which allows a range. Although I cannot change it….
=SUM(IF(EXACT(B1:AF99, "LB"),1))+SUM(IF(EXACT(B1:AF99, "lb"),0.5))
View 3 Replies
View Related
May 13, 2014
I have a pretty simple spreadsheet with two columns. In Column A is a unique identifier for a user (608901, 505141, etc.). In Column B is a date the user logged in (5/1/2014). For a week's span there are about 25k rows.
Users can and do log in multiple times per day creating duplicate entries for a single day (680717 might show up 3 times for 5/1/2014). What I need to figure out is how to get a count of all unique logins per day. So if 680717 in previous example logged in 80 times on 5/1/2014, that only counts as 1 unique login for 5/1/2014.
View 6 Replies
View Related
Jun 17, 2009
I have an array formula which reads:
{=SUM(IF(Female2!$A$2:$A$5000=$A403,IF(Female2!$C$2:$C$5000=C$402,IF(Female2!$1:$1=C$401,1,0))))}
However this formula only counts the number of cells (returns 96 for 96 cells) rather than adding the numbers in those cells to come to a total of 34.
View 4 Replies
View Related
Sep 28, 2011
How to calculate a count of unique records across two columns (customer number and acct number) with out much luck. For example, a customer number may appear 3 times but be associated with 3 separate acct numbers.
I've found a lot of in-depth formulas online but I'm not sure if they're what I need. I think I need some sort of array formula but I'm a little stuck.
View 9 Replies
View Related
Oct 17, 2011
I have a series of numbers going down from max to min in column M, in column N I have the number of counts of the same numbers.
The Modal value is calculated by a formula and already displayed in cell F3 (it needs no modification).
What I am trying to do is this:
1) Identify the address of the same modal value in column M.
2) From the modal values address in column M, search Column N searching upwards and downwards from the modal value address, until the first instance of the pre-specified count number is identified.
3) When the pre-specified count number is identified look beside in the cell in column M and display the value beside that pre-specified count in cell.
We stop at the first instance of that prespecified count both when 1) counting upwards and 2) counting downwards.
The upper value is displayed in F2 and the lower value is displayed in F4.
An example would be.
1 1
2 2
3 3
4 4
5 6
6 1
7 2
8 3
9 4
10 1
The modal value is 5 looking beside it as it has 6 counts, so in the count column we search upwards from the count of 6 until we encounter the pre-specified number of 4, then we look beside the count of 4 and observe that the number 4 above the modal value has 4 counts hence we display the number, now we search downwards from 6 counts until we reach the first instance of 4 we find it and the cell beside it contains the number 9 so we display the number 9.
The end result is numbers 4 and 9 that have 4 counts each.
View 9 Replies
View Related
Jan 21, 2009
I have data created by a program where it gives me a column "Code" with different text categories (in this case names of people). One person appears multiple times in this column as it track each time they register a statistic for the sporting event. The statistics are text fields registered under the column Labels
So I have two columns titled "Codes" and "Labels"
I need to extrapolate from this data a count of times each statistic happens for a specific player.
Example:
Code: Labels:
John FGA
John FGM
Joe FGA
Joe OREB
Zach TO
What I need is broken down by player with counts of each category FGA, FGM, OREB ect specific for each player creating a box score for the event.
View 9 Replies
View Related
Feb 4, 2007
i know its out there, i just cant find it. I have a list of names in a specific pattern of cells on a spreadsheet. I would like excel to give me a number of how many names i have in this spreadsheet. I know COUNT does numbers, but is there a formula that counts names?
View 2 Replies
View Related
Apr 19, 2007
I encounter some problem in excel. I would like to get the counts that satisfy two more conditions. For example, I want the count that is both "m" in column F and "1 yes" in column G. Do I use COUNTIF or some other functions? i try COUNTIF it doesnt work well, the counts obtained doest satisfy both conditions.
View 2 Replies
View Related
Sep 14, 2013
I have a range that contains a mixture of hard coded data and data pulled from a database sheet. I want to average only the hard coded data not the ones in the cells containing formula. I need this to be dynamic instead of just selecting the cells as formula might be added later on.
View 1 Replies
View Related
Jul 28, 2014
I have the following formula to count the time between two dates and result in an answer with months/days:
=DATEDIF(E14,E15,"M")&" months "&DATEDIF(E14,E15,"MD")&" days"
The problem is that the function does not count the start date. Is there any way to modify this formula so that the start date is included?
For example if the start date is 02/01/2012 and the end date is 02/28/2012 it results in 27 days but I want it to result in 28 days or 1 month.
how to go about this or if there are any better date functions out there?
View 2 Replies
View Related
Feb 4, 2010
I have using the following Formula: =COUNTA(A3:A7,A10:A14,A17:A21,A24:A28,A31:A35)
Basically is counts how many week days there are in a particular month. Now I have a cell (B47) that counts how many Bank Holidays are in that month. I am having trouble using the formula then minus B47. I must be missing something really simple.
View 3 Replies
View Related
Dec 10, 2012
I have a spreadsheet similar to this:
Name........Cat....Dog....Fish....Mouse
NY............Cat.....Dog....Fish..........
NY............Cat...............Fish....Mouse
DC.....................Dog..............Mouse
DC...............................Fish............
CA ...........Cat................................
I want to create a pivot table to do this:
Name.........Cat....Dog....Fish....Mouse
NY...............2.......1.........2........1..
DC...............1......1..........1............
CA ...............1.............................
I have been unable to get it formatted correctly. The closest I get are "sub-colums" with counts.
View 2 Replies
View Related
Dec 24, 2012
I have a query with regards to Counts
This is my below data.
No.Request NoDateSilverGold
1456661-Dec-20121
22018561-Dec-20121
32089561-Dec-20122
42099721-Dec-20128
52012121-Dec-20122
62068782-Dec-20122
72075952-Dec-20123
82045682-Dec-20123
92032252-Dec-20122
102015852-Dec-20121
in other sheet i have products Data by date wise
1-Dec-122-Dec-123-Dec-12
TotalRequest countTotalRequest countTotalRequest count
ABSilver2
Gold12
My query is how to get the total Request Count for Silver and Gold by date wise. Eg: Answer should be Silver has 2 (counts) & Gold has 3 (counts) How to arrive to that.. i have tried.. countif, countifs....
View 3 Replies
View Related
Apr 25, 2013
I am working on a sheet that has over 150 tabs of information. It is a simple audit that allows for Yes, No or N/A to be selected for each audit category. I have an Outcome Summary tab that is pulling totals for all the audit information on each tab. I did a CountA statement to count any cells (from all worksheets) that had anything selected, so I have my count for the amount of files audited, but for the life of me I cannot come up with a formula that counts the ones that passed or failed the audit. Needs a formula that counts for Yes as 1, No as 0, N/A as 1 (these don't count against us) and doesn't return an error for a tab that wasn't selected.
View 3 Replies
View Related
Jun 10, 2013
I am trying to see if there is a way using count or another option, of using one formula to look in a column and then spit out how many of each item are there:
i.e: lets say it says a, b, c, d etc...
Can a formula go through and say you have 3 of a, 5 of b and so on
I understand the basic of count sum iserror etc, just not sure if excel can do what I am wanting or if i should use access.
View 2 Replies
View Related
Feb 17, 2014
How do I write a bar chart which reads the format of a cell instead of the content? ie I want to count how many cells in each column are amber. Amber cells have already been decided by conditional formatting.
See demo attached : bar chart demo.xlsx‎
View 6 Replies
View Related