frequency

In Column A, I have numbers from 1 to 40. From cell B16 and so on, I want to display a series of 9 continuous numbers which did not appear in last 15 rows(range A1:A15) COLUMN A 1 12 24 40 35 30 33 2 25 17 8 0 20 39 30 DISPLAY "NONE" as no continuous 9 numbers were missing in the last 15...

I have following formula in Cell B11. =IF((COUNTA(A2:A10)-COUNTIF(A2:A10,A2))=6,"Y","") It checks if the value of A2 cell appeared 3 times in a last nine rows and show Y or else remain blank. I want to check values of all 9 cells from A2:A10 and display VALUE in B11 only if following...

Hello All, I would like to count frequency of values in column A, so when I drag the formula down it should count the number of times the valued in column A appears up to the point where the formula is. This is how I want. <tbody> VALUES FREQUENCY H&M 1 H&M 2 H&M 3 DJ 1 DJ 2 H&M 4...

I'm looking for help to figure out how to count how many times a number occurs in a range of cells where there are multiple numbers per cell. For example, if the range I'm searching has 351, 123, 240, 95, 28 and 111 located in multiple cells (not in any single column or row), how do I count...

Hello. I am trying to have a formula that will count the number of consecutive cells using a starting point. I have used the threads to find the number of consecutive cells in a range but I only want to have the number of consecutive cells starting at the left most. Below is an example where...

Hey Everybody! I hope you guys are having a great day! I am currently working on something and I am really stuck and was wondering whether anybody had an idea of how to solve this problem. So If you look in the spreadsheet which I have attached in column H you can see a long list of data...

Hi Everyone, I'm not that technical and I'm hoping someone wouldn't mind helping. I have multiple data sets which vary both in range (lower and upper bounds?). Each data set will also change for each new scenario, for example on any given date Set 1 might have a range of -4 to +4 and the next...

I have a list of projects that have a start and end date in an excel file. I want to find out how many projects were live for each month. For Example, here is some data: Project 1 started 11/1/2014 and ended 10/31/2015. Project 2 started 12/1/2014 and ended 3/30/2015. From that data, I need a...

Hi, This is my very first post, and I have to admit, this is the second place where I look after some help because it seems my goal is not so easy. :( I'm examining relative frequency and I have absolutely no clue, how to solve the following thing. I have a - let's say - sequence with values...

Hello, I am struggling trying to get a count formula to count a number of transactions (with duplicate numbers) only once within a date range in a table containing over 60 months. In the example below, I need to count the number of transactions (which has duplicates and I need them to be...

Hi guys, I´m new to the forum. I´m having trouble with a formula that would allow me to search for the frequency of a column conditioned to anothe column, I can´t use pivot tables since the data comes from a Query from SQL that needs to be automated on excel. <tbody> Count Merchant...

Dear Excel Gurus, I would like to know, if there are ways to deal with my "challenge". I would like to create a Chart or historical graph that shows that a material code has been mentioned in January and December and November, or Only maybe in January and December. Its what i would like to...

Hi, I'm breaking my head over this, I wonder if any of you could help me out. I work in a small library and I'm trying to rank our most frequent users. We already have a table with every borrowing of a book, with the name of the user in a column. How many times the user appears is equal to how...

Please note that my skills are few and far between. I have tried the following formula with CTRL+SHIFT+ENTER but it returns zero. I need to find the unique # of customers that purchased material each month. Here is the formula that failed...

Hi, I have searched far and wide for a solution to this and spent hours trying to figure it out, and I am now admiting defeat and hoping someone will be able to help me. I have the following type of data: Example dataset: <tbody> A B C D E 1 Level Time Bin Range Level Frequency Level...

I am sure there is an easy solution to this, that I just can't see. I have many payments due quarterly, each with differing start months. For a given month, I need to know if a payment will be due. For example, using the table below, the £100 in the first row is due in Jan, Apr, Jul, Oct the...

Hi There, I'm a relative novice at Excel and I'm having trouble working out a formula. I'm trying to count the unique numbers in ROW G (Sectors) if certain criteria are met in other cells. For example, IF (1_hypothesis = 9) AND (1_for/against = D OR 1_for/against = CF) AND (1_thick/thin =...

Hi Guys, Ive tried playing around and I cant get it to work correctly. I have the original formula below but now I need it to sum if column A is unique. I tried with frequency but i cant seem to get it to work. =SUMIFS('Nego Stats'!$AM:$AM,'Nego Stats'!$F:$F,"New SA",'Nego Stats'!$Q:$Q,"CM")...

<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody> Count Repeat Emp # CSR TM Group Presence Schedule Note Year 1 Yes 3133930 Nancy Gab FR Yes Day N/A 2016 2 No 45490 Angela MArvin FR No Day N/A 2015...

Hello, I'm really struggling with this one. I read a few articles and even watched a video, but it's not working out for me. I have a list of team members (e.g., Joe, Mary, Bill) in Col A. Each name appears once in the list. No name is repeated. For each name, I have a cell with the number...