frequency

Hi, I am setting up a family budget planner, and want to list the fixed outgoings (Description / Amount / Frequency [Monthly / Weekly / Bi-Weekly] / First Date Taken. The variable outgoings, I want to list in a separate table (Date / Description / Amount). The problem I am having is as...

I have a problem where I need to rank locations based on two separate criteria without duplicates. I have exhausted my Excel friends and researched options but cannot seem to get a formula to do what I need. I've even tried to figure out a helper column with no luck. Please help if you can: My...

It's possibly my search-fu is failing me here, or more likely I simply don't understand the answers I've found. I'm working on a project (due to some backend db errors that will eventually be resolved) that requires me to tabulate the duration of certain phone states. Unfortunately, the...

Hi All I'm trying to work out a formula to count the number of consecutive numbers in a row of numbers e.g if I have a series of numbers, say 1, 3, 4 ,5 12, 15, 16 I want to know how many numbers are consecutive, in this example 3,4 +5 =3 consecutive numbers and 15 + 16 = 2 consecutive numbers...

Hi All, I'm trying to generate a list of 7 random numbers from a list of 45 numbers which each have a previous frequency of selection. I'm trying to weight the random numbers to the previous frequency. Any assistance would be great! Kind Regards, Andy <colgroup><col...

Hello peeps, First time poster looking for some help :biggrin: In my representative scenario I have a range of items (Apples, Oranges and pears), each repeated in a list with an associated quantity (number of pips). I want to find out:a) the number of unique entries for each item (Unique...

Hi! I'm not sure how to go about solving this - but I need to do an analysis using excel charts to assess if there is a trend between the performance of a list of managers handling their team of staff who are ranked either successful / unsuccessful vs the frequency of their attempts. So my...

Hi, I have list of data where I need to analyze the frequency of when my employees are buying mobile phones. I have a list consisting of the following information: - Employee - Date of purchase I want to find out how often each employee orders a new phone (number of days between each...

Hi Wondered whether any bright spark out there might be able to advise on this? e.g. if i was looking to say what score (e.g. in a test) a 'top decile' student scored, if the data was like this? <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Score Frequency...

<tbody> Public 1 2017 Public 2 2018 Private 3 2017 Private 3 2018 Private 4 2018 </tbody> So I'm trying to count the number of unique combinations of the first two columns, then according to the date. I currently have...

Hello all I hope you can help on this one I want to work out what the cycle dates should be but not to include a Sat or Sun in the dates A1 cell value will be a date B1 cell value wll be the frequency per year C1,D1,E1 etc would be the dates Example "A1" = 9/1/2018 "B1" = 1 "C1" = 9/1/2018...

Hi All, I wondered if anyone can help me with a simple formula to automatically input activity cost data on the basis of frequency intervals. Below is a simple example the cells in green are input by the user, the yellow ones I would like to be calculated by a formula. <tbody> A B C D E...

Hi, I would really like to get some help on this model that I am building. Imagine the following data <tbody> Customer Amount Start Date End Date Frequency Jan Feb Mar Apr May Jun July Aug Sep Oct Nov Dec Jan 18 Feb 18 John Pree $2000 05/02/17 05/02/18 4 500 500 500 500 Mary...

Hello, I would like some help please! I am trying to create a formula to show results of "frequency" based on "accuracy". My spreadsheet is 150 rows; each row has a frequency result: <tbody> <tbody> Accuracy Frequency ≥99.5% 1x/yr. ≥98.0% but <99.5% 2x/yr. <98.0% 4x/yr...

Hi, I am looking for a code that returns the count / frequency of transactions where any two or more items are sold together for eg. <colgroup><col><col></colgroup><tbody> Transaction No. Item 10020 apple 10021 apple 10021 banana 10021 carrot 10022 apple 10022 banana 10023 lemon...

Hi, I am not sure if this can be done with formulas and Excel tables, or whether I should try something in VBA. What do you think? I need help from design point of view, what do you think should be utilized. for each id in input table numRows = countif frequency rows + nonempty cells within...

Hello, I am trying to use the frequency formula, but with multiple values. For example: I have 2 columns: "'Nth' Visit" and "Days between visits". In the "nth" visit it shows which number visit a certain date is for a customer. This ranges from 1 visit to 7 visits. What i am wanting to do...

I am looking for assistance with counting the frequency that TIMEOUT appears consecutively for each driver on each day. I'm looking for instances TIMEOUT appears 3 times consecutively for a driver on a given day. At that point I'd like to know the number of rows that appear after the 3rd...

I would like to create a pie graph that shows the frequency of the number of times a customer has bought, e.g. how many bought 1 time, how many bought 2 times, etc. The raw information looks like this: The total orders is a calculated measure: Customer Total Orders =...

I have a set of data that I would like to create bins. For example, 45, 23, and 10 will fall in the 0-49 bin. I created the histogram but am struggling in changing the ranges to display as the bins as the ranges below.:confused: Data: 45 23 897 456 123 10 Bins 0 - 49 50 - 99 100 - 175 176 -...