I have a spreadsheet with 3 sheets, the first sheet is to be an overview of the entire workbook used to keep track of training,
The last sheet (Called Raw_Data) contains various coloumns, the two I am interested in is the training course and the name, as someone completes a course I record what the course was, who did it and date/time of start/finish,
What I would like to do it to count on the front sheet how many times someone has completed a course
Incident Handling Processes
Incident Handling Processes
From the above table Job blogs should flag in a cell for Incident Handling Processes twice, Is this something that can be done via a formula as I am trying to avoid VBA.
I'm trying to compare values in 2 separate columns to see how many times the same value appears in both columns. Ideally I would be able to insert a range function to compare the values in the column "ID 1" against the values in column "ID 2" and return the count of times that a value appears in both columns. For example 2122, 1112 and 1718 appear in both columns and I would like the formula to return a count of 3.
This is a very simple thing that i can't seem to figure out or find the right code in search.
How do i count the number of columns in an excel worksheet? - No selection should be made - If it helps, the worksheet only shows the columns and rows with data, if there are no data there are no columns, something about the Page break view...
I want to have the number of used columns in a worksheet. The information will be used to understand what range the data is in. So for the rows I am using nRows = Application.WorksheetFunction.CountA(myRange). I am hoping to have something similar for the columns.
How can I count all the cell text from different columns?
I have a sheet..that has the well known columns from A to EM, but let's say A to Z (A,B,C,etc).
I want to count all the cells that have text inside from columns: A,C,E,G,I (so, from 2 to 2). But the counting to be for all these A,C,E,G,I, etc columns, and to be put in a cell which gives this total number as info for user.
So, in general I do have two columns F and G taken from the other xls.
Age is obviously difference between today and open date
Open date is open date.
I made a table like:
Age and due date.png
In this case, I have 3 rows where there is no open date extracted, therefore is no age. The counter stops on them and shows 529 in total instead of 532 or shows the age as far more than 365 days. How can I count the blank cells, but only in the range of the list I do have, not the all blanks I have from the beginning till the end of the column, so I could (for similar in this case) have 3 blanks cells counted?
Sometimes is also stuck in the middle of counting (when blanks are inside there) and the total number is even smaller. What function can I use to count these 3 (or less, more inn the future) as BLANK to have the total numbers realistic?
I am using Excel 2007 on Windows XP. I have written up a questionnaire that allows the user to simply check boxes in the cells. My problem is coming up with a formula to count the number of boxes have been checked. I tried several count formulas without any luck. I think one of the problems is that when I highlight the cells with these check boxes it doesn't actually show in data in the fx line.
BP Formula.xlsxI'm not sure what formula to use or if Excel can do this. I want to use it to determine number of blood pressures in a certain range. So if I use column A for SBP (systolic BP) and column B for DBP (diastolic BP). I want a formula to tell me if column A is between 140-159 or column B is between 90-99. I can get that part, but what I'm having trouble with is it counting each row twice if both column A and B meet the criteria, whereas I want every row (person) to only be counted once if either column A OR column B meet the criteria. (See attachment)
I'm on Excel 2003 and have a sheet to track people who have read my emails. I want to know the answers to the questions below. I've included a fake sample to show what I'm looking at. The number of cells in each column is much higher and not the same per column. I've tried variations of MATCH, VLOOKUP, SUMPRODUCT, etc. but haven't found a good way to set up a formula.....
I have this data lets say id denotes a particular house and the multiple entries of the same house are for different members of a house. Now i want to calculate the total no of people who earn in a particular household i.e if a cell is filled or not.
Fixed data labels over a number of columns and i want to count the number of times 2 of these appear however when ive tried to use the countifs function it will only count if in the first colum of the range selected and for example if A2 says 'FRANCE' and D1 'RED'
Ie i have been using COUNTIFS('Datasheet'!BB:BE,A1,'datasheet'!BE:BH,D1)
I have a spreadsheet with over 15 columns showing drivers (names numbers etc) and their duties with more inf.
What I need is to be able to find when a certain type of driver in column A (drivers belong to different rutes) say from route A is at rest (this is shown as RD) which is shown in column B and then be able to count how many times those two exact events occur.
I have two columns of data: 1 column can be possibly anything, either numeric, alphanumeric, or alpha only (VINS or vehicle numbers). The adjacent column are four different types of vehicles. I've tried concatentating the two to try and count the unique combinations (a truck maybe used more than once during the day), which I can get unique values, but not unique values for each type. Also, the range sizes are variable, but no more that 65 rows.
5CZ975 Van 25RW04 Straight 5CZ975 Van ZJ6026 Van
So, the result I am after is 2 vans, 1 straight truck
I found an array in a another post, but it is not working properly (see cell F7 in the attached):
I have a data set with rows of data, with a header row along the top. I want to sort my rows of data by column when the cell above the appropriate column is pressed. I know this seems cumbersome - but it fits in with the sheet. The sheet is protected, and we only want the user to be able to sort in this fashion. My problem is, with my code, I get an error when you select a range of two of the header cells. The case selection on the target.column gets confused. How can I check to see if it's just one cell? Is there a property of a range that reflects how many rows or columns it contains? I tried the following (marked with the ' )just from picking out of the pop-up list of properties of the Target range in SelectionChange, but obviously it doesn't work. My original code is the un-'-ed code.
Private Sub Worksheet_SelectionChange(ByVal Target As Range) ' If Target.Rows = 1 And Target.Columns = 1 Then If Target.Row = SortRow Then Select Case Target.Column Case PriorityColumn SortData PriorityColumn Case JobColumn SortData JobColumn Case NotesColumn SortData NotesColumn Case SupervisorColumn SortData SupervisorColumn Case ShutdownColumn SortData ShutdownColumn............................
I have a sheet with data which is all sorted by columns.
What I want to be able to count the occurrence of an instance when 2 cells in the same row (but in different columns) match my given criteria.
Ive been using 'countif' to count the instances in a single column and I am now aware that this is about all it can be used for.
An example of my data is:
A B 1 a 1 a 1 c 2 d 2 c 3 b 3 b 3 c 3 d
What I want to be able to count for example is how many times '3' & 'b' occur on the same row (in this case the answer would be 2).
Im not very good with pivot tables and have tried but have not managed to find an answer. I really hope that someone can help as Ive been working on this probelm for days and quite frankly its doing my head in :-)
I've been desperately trying to figure out a formula that allows me to count the number of rows in a column that have different values, but that only counts those rows in which other conditions have been met. Probably sounds a little confusing, which is why I'll illustrate it with a screenshot:
The file contains a listing of major executives of a variety of different firms in different years from 1992 onwards. In the screenshot for example, you see the executives of AAR Corp from 1992 to 1997. Since my file however consists of 240,000 rows, there's a number of c. 2400 firms with their executives over a time period of 20 years each. Since not necessarily all executives remain with their companies for the rest of their lives, some executives show up for a number of different firms in my sample.
I want to determine at how many firms each executive worked within his current industry up to the respective year, based on the information of the 2400 companies and executive data over 20 years. The current industry is classified by 1 digit SIC codes (column U) and each firm has an individual firm identifier which is the CUSIP in column S.
For example, when applying this to the first row in the screenshot (Ira Eichner), I would need a formula that counts the number of different CUSIPs (thus firms), given that the EXECID (executive ID, identifier for each executive; column I) equals 9248, the 1 digit SIC code (column U) equals 5, and the Year (column J) is below 1992.