is there an IF formula to compare values in two columns, say Column A and Column B have "Action recommended" and column B has "Actual action taken", both columns should have the same texts, in cases where there is no similarity, the formula should count the cases.
Now i want to select member column values based on the differences in values between members of location column should be 50000, it means if select web then my next selection should be SEB because next value (i.e web + 50000) is 100000 and it is matching to SEB in members column.
I've got a list of numbers and want to show the difference between the highest number and each of the other numbers. Here's an example: (The first column is the position, the second column is the number and the third column is the difference.)
PART 1 - A record is created - The record is modified once/several times - Only the original record and the last modified record needs to be kept
PART 2 - The differences between the original and the last record need to be highlighted in the spreadsheet. - This has to be repeated for a whole bunch of rows
Currently I am manually deleting the rows and eye-balling the changes. I'm using Excel 2002. I have ASAP Utitilities as well. Although macros are cool, I was hoping I could try with an Add-in or software.
I have a workbook where I am trying to COUNT the values greater than zero in column "J" based on a selective criteria of column "B".
In other words, if the date in a column "B" cell (B3:B78) is greater than the date in A86, I want to count the number of cells whose corresponding value in the "J" column is greater than "0". And then I want to take this selective COUNT and divide it by a COUNT of all the cells in the range "J3:J78".
So I have an annoying dataset to work with. The first column contains ID#, string, string, string, ID#, string, string, string, string, ID#, string, and so on. It is basically a list of patient numbers with a list of their appointments listed underneath them. I need to find a way to count up the number of strings for each patient, like shown below:
Patient# Count
101 2
Had an appointment
Had an appointment
Deleted-Had an appointment
The format isn't too important. The data I have is basically column A, and I want to create column B.
Im trying to find out a way of counting the contents of, say: column C where that contains text as long as column B = a variable
Basically column C contains the words Sale and Lead and i need a function that reads column B for examples of a user defined variable (1-4) and counts sale or lead in column C if this condition is satisfied.
like a sumif but capable of adding text (two cases of in this example but not really vital as the only things in column C would be sale, lead or left blank)?
what i need to do is count all the instances in column h excluding headers so in the attached sheet. in a2 i need it to return one of the teams ( in this instance sheffield wednesday) and then in cell b2 i would like it to return how many times (sheffield wednesday) appears in column h in c2 draw. in d2 i would like it to return how many times (draw) appears in column h and the same again in e2 and f2 for the other team. i need it to understand that it may be any team as the next set i use may be for instance utd v chelsea etc etc. in row 3 there will be ( which there isnt now a filter )
I have list of states in column. Here I need to the group the cities and take the maximum counts for all those states. I have a huge data to do it. The countif() formula is taking too much of time. find the attachment.
I have a column of names and I want to find the frequency that each name occurs per row, but the cells have a string of text. For example:
Column A: John Dimon, Matt Carpenter, James Chan, Gary Smith Matt Carpenter, Leo Monroe, Craig Thomson John Dimon, Matt Carpenter, Larry Barclay
I would like a way to count how many times each name occurs in the column. So John Dimon would be 2, Matt Carpenter would be 3. I tried countif but it doesn't seem to work with a string of text.
I have a worksheet that has several dates in column D. I would like a formula to count the number of dates that are 7 days or less than the current date in F2.
I have a list of 60,000 names in a spreadsheed, column A has the NAME, Column B the STREET NUMBER and Column C the STREET NAME. Heres a small sample.
WADE FRED100603RD ST CHALWIN E100733RD ST JAQUE D J101263RD ST JAQUE D J101263RD ST JAQUE D J101263RD ST JAQUE D J101263RD ST JAQUE D J101263RD ST BAXTER P M101593RD ST BAXTER P M101593RD ST MCLEOD E A101603RD ST MCLEOD E A101603RD ST MCLEOD E A101603RD ST
As you can see some of the names repeat, and that is exactly what I want. I want to write a formula in Column D that will indicate how many times each name appears so that it will show, for example, a "5" beside JAQUE D J" and a "2" beside "BAXTER P M".
I have tried using EXACT, MODE, IF ... COUNTIF wouldn't work because there will be some names that are duplicate but at different addresses, besides the range would be enormous.
I tried using the following code to count the number of entries in a column (Column A, text entries) and then display it as a percentage of the total in a separate box. I just got the result "1".
Sub Count_Selection() Range("a1").Activate Dim cell As Object Dim count As Integer count = 0 For Each cell In Selection count = count + 1 Next cell Range("g1").Value = count End Sub
How do I go about having a formula which will return the number of times 0 is repeated in a column sequentially?
e.g.:
0 1 0 0 0 0 0 1 0 0 0
The idea being that after row 7 (there have been 5 consecutive zeroes), the count would reset when it hits a value greater than zero, and then count again once it hits a zero again.
How can I count the number of unique values in a column?
I have a spreadsheet that lists transactions that occurred over a one-year period (2007). I need to determine the number of days our facility was operational. No transactions on a particular date (25-Dec-07, for example) and the facility would be considered to have been closed on that date.
On the days that the facility was open, multiple transactions would have occurred on those open days and those multiple tranactions are all reflected in the worksheet.
So I need to count each occurrence of '01-Jan-07', '02-Jan-07', and so on.
how can I count the number of not empty rows(and for example too many) using do.. until loop kind. I am searching on the net for about 24 hours but I couldn't find it.
Ok so I am trying to streamline the Shirt ordering process at my work. I have made a table with Employee names as Column A, then Row 1 is shirt sizes from small to XXXL. The Cell values are going to be the colors people want. I want to total the number of each size/color combination. But someone may want more than one of the same color. For instance you would enter "BK, BK" if you wanted 2 black shirts of that size. This is where the issue with COUNTIF comes in. If a cell has the same value twice, it only counts it as one because counts the cells with an instance of a value, not the actual count of instances. Is there a way to make COUNTIF or a better function for this?
I'm using a sumproduct forumla to count rows based on specific data in multiple columns. So if column A equals 1 and column G does not equal 6 and column M equals 4 then count that row. I know how to do this. The problem I'm having is that I want to count column A if equals 1 or 2. I tried adding an OR comand in with my sumproduct but it doesn't seem to work that way.
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.
I want it to count and fill in a range in column A until it sees a blank or notices the change in value in column B. In the example below i hope it shows what i need to do. i left the last group without numbers to show that is where it needs to start counting over again. i am basically wanting to count down 1st place 2nd place etc.
I want to count the number of times a certain value is found in columnB, only for unique values in columnA.
I have made a simple example file, attached. Column B shows Status which can be Active, Current, Dormant. Column A holds Item names. I want to know how many Active Items I have, but an Item can appear more than once in ColA, so I want it only to include in the count the unique ColA values.
Need a formula for counting the number of occurences of a month & year in a date column? The spreadsheet is looking at items raised in any given month e.g. all items raised in Dec-08.
I need to be able to count items if they match a condition in another column, as below
A B 1 Apple Red 2 Apple Green 3 Apple Red 4 Pear Green 5 Apple Red 6 Pear Green 7 Pear Red 8 Apple Red
How can I count how many Red Apples there are. The answer should be 4 but when I use countifs I can either count the no of apples in Col. A or the no of colour Red in Col. B.
I have tried every combination of if, vlookup, and count that I can but keep getting errors or single col. counting.