My data is a list of (in reality 3000x larger). users and the company they belong to. I want to find out how many companies have 1,2,3,4,5 and more than 5 users. Any idea? I am using a pivot table to find out the number of users per company (easy so far) but then I get stuck when I want to use a countif with getpivotdata...
I need to count the number of equal cells in col D beginning at the top of the column. The counted cells must begin with a text prefix of "Category:" without the quotes.
Some but not all of the cells in col D begin with a prefix of "Category:" without the quotes, followed by a word or words following the word "Category:" See examples below. All of the terms prefixed with "Category:" in col D are in alphabetical order. I need to count the number of identical cells in col D with the "Category:" prefix.
Examples of the contents of cells in col D with the "Category:" prefix are as follows:
going down are stores a, b, c, d.... what i'm filing in across is the square feet of each store and what quartr or year each store came into place. so there will either be a 0 or a number Now, I want to be able to count the number of nhew stores each quarter. how do i create a formula that just recognizes it the first time there is a number and not a zero... because i will put the square feet in subsequent quarters after it opens so i can see yearly how many square feet the store had. then also, how can create a button on the page that will say quarterly numbers and a button that is annual. so that i can hide the quarterly columns and just see an annual spreadsheet... and for the quarterly button so i can hide the annuals and just see the quarters....
I have data in a column (G) consisting of zero and ones. I would like to count the number of clusters of the number 1 in the data. For example in the data below there are 8 ones. But instead, I need to calculate how many groups of 1s occur. So in the case below the group of 1s = 3.
In terms of what defines a group. Whenever there is a zero either before or after the occurance of a 1 constitues a group, i.e the groups are broken out by zeros.
I want to count the number of times any given number appears either as a consecutive group or singularly.
To give you a context I monitor windturbines and for any given fault code I wish to count the number of events it occurs in a month. Now it could be for 1 hour then clear the next then back for 17 then claer again. That would be 2 events!
Create some sort of formula combination or macro that will: Recognise a cell with a value of 1, 2 or 3 in. If 3 is in the cell, the cell to its left will be counted and added to a total. If the cell that has 3 in changes the value is removed from the total. Ive tried lots of methods but i cant figure this one out!
That mean from number 1 to number 2 have 42 + 2 = 44 row (this value put in A 45) number 2 to number 3 have 40(because 2 row have add to number 1) + 1 = 41 row (this value put in A 46) number 3 to number 4 have 41 + 42 = 83 row. (and this one put in A 47)
When you click on an entire column and drag your mouse to the right/left, you get a little box that tells you the number of columns highlighted, actual the same with rows. This little box has stopped coming up on my Managers laptop. I have looked in the View tab and the options area but nothing jumped out at me as the fix...
-Sheet1 has a list of numbers in column A. -Sheet2 has a list of numbers with some numbers appear more than one in column B.
-I need to write a macro that start with the first number in sheet1 and go to sheet2 and count how many time that number appear. If the number of count more than 1 then highlight it in sheet 1, or copy it into a new sheet.
-Go back to sheet1 and start with the next number in the column until finish.
What I am trying to do is take the dates in Column B and count each date as a month, and put those totals into the January through December boxes. I've put in the amounts that should be shown with the data I provided.
Is there an equation to count numbers greater than zero without adding an additional column?
I had a COUNTIF equation but realized that the criteria that I used to use required an additional column. The additional column I used to have would be something along the lines of =IF(A1>0, "x", "") and then count the X's. I was just wondering if there was another equation that could reduce that step.
If I have the numbers 1-50 repeating in columns, 1-50, 1-50 etc is there a way to determine that number "1" falls 1st, 51st etc in the sequence without doing a manual count? Or that the number 2 falls 2nd, 52nd etc?
I have a have a userform that uses a macro to save data to a worksheet and i want to display the row number using a loop ie if column B3 is not empty/contains a values add a number 1 in column A3 and so on everytime a record is added.
I have a list and the list contains the same string multiple times. I am trying to take that list and print it in column D and then list in column E the number of times that string appears in column A. S for example I would like the list to output
Col A | Col B| ....| Col D | Col E | String1__________String1 3 String1__________String2 1 String1__________String3 2 String2 String3 String3
i need a formula to count the number of cells in a column that HAVE a specific value (for example 1123). I tried the COUNT and COUNTIF function but it counts all the cell that CONTAIN the number 1123, i just need the cells that are EQUAL to 1123.
We have a sales table that 23 sales people update then send back to me. So each week I receive 23 worksheets.
The number of columns in the tables I get back can vary, depending on what each salesperson is reporting for that week.
I have written a macro that takes each sheet, automatically finds the last column and then adds two new columns of summary data.
I use COUNTA on the header row to find the number of colums. This usually works fine - but there is one problem that can occur.
Sometimes people insert one or more blank columns in the table. So how can I find the last column, because COUNTA won't work? (I do not want to simply delete these columns because some people have set up vlookups and their own macros based on the position of the columns they have defined, including the blanks.)