counts

I have this formula =LEN(B4)-LEN(SUBSTITUTE(B4,",",""))+1 which counts the comma separated values in cells. My problem is the formula counts the blank cells which contains formulas as 1. How can I fix this? thanks. for example: if B4 is {1,2,3}, the result will be 3. if B4 is {25}, the...

Hi, I'm wanting a formula that will count a cell if it contains 1 and or 1a, 1b, 1c etc. I currently use "1?" but this only counts the cells with 1a,1b,1c in any ideas how I can get it to count the 1 cells aswell? Hope it makes sense. Thanks in advance Clare

Using Excel 2000 Hi, Perhaps this query is not so easy as title looks in fact the question is 2 in 1, 1st find the cycle and then the count's Data are in cells C6:C82 change colour shows the cycle for "1X2" - E6:F11 are the start & end cycle patterns - G6:G11 is the result counts of...

Hello everyone, I would like to copy values from Sheet A to Sheet B. Sheet A has a drop-down (data validation list) and items in that sheet change according to the item that is selected. E.g.: Items in the drop-down are Apples, Oranges, Bananas. Below the drop-down I have monthly counts...

I am trying to write a formula that will reference a column and give me a count of all cells that have the specified year in them. Example column H will various years worth of data in this format 1/01/2017 and I am attempting to get counts of each years total, so month and day are pretty much...

I have a lot of records that look like the list below. Its the data from entries to our film club. At the end of the year there will be 40,000 records. The list gets added to every week. I need to know the number of valid entries for each week and day. The week is the penultimate field (51 in...

Hi! Hope you're feeling good. I have 2 columns A & B. For now I have 1 column of data points from A7 down as shown below. I'm looking for a formula in B7 (that I'll fill down) that will do the following: Keeps a count of consecutive # of rows that are increasing in magnitude IN THE SAME...

Hey there, So I have a Pivot Table which has a few slicers. I want to insert a field that shows the % count of the total amount... Example - lets say I have a column of data that is the following colors: red, red, orange, orange, orange, yellow, yellow, yellow, blue, and blue. When I select...

Hello World, I think I have a challenge here, or maybe this is an excel limitation. I need to count the unique Ticket Numbers (Column B) for a given month / date range (Column E), but also segregate it out by Place (Column D) uniquely. The table to the left is the source of the information...

Hi, hope you're doing great today. In column B, I have # of events, like this: <tbody> 2 1 1 2 1 4 </tbody> In column C, I have Day number of week, eg: <tbody> 4 (which is Wed) 5 6 7 1 2 </tbody> In column D, I have (if needed), the actual weekday name (eg TUE, etc)...

Hello, I found the following code in several places on the internet. It works beautifully. Is there a way to modify the output so that instead of popluating a message box it populates a worksheet? I want to be able to build a pivot off of it, manipulate it, etc. Sub HowManyEmails()...

Hi there Hoping you can help. I'm a newbie to this forum, hope below makes sense In summary I have a spreadsheet where I log technician hours as well as holidays and sick days I have the date and day of the week in AA1, AA2 (entered as WEEKDAY(AA1,1) and AA3 is where I log the hours worked...

Hi All, Looking for an Excel solution (I have Excel 2010-Mac) to the following problem: I have a list of 20,000 numbers (deciphering bioinformatics data) and would like to have a formula that would be able to perform a Sum to a specific number and then tell me how many cells were used to reach...