# Identify All Consecutive Intervals

Sep 18, 2013Is there a formula that can identify all the consecutive intervals that have value below 90%.

View 1 RepliesIs there a formula that can identify all the consecutive intervals that have value below 90%.

View 1 RepliesADVERTISEMENT

I am trying to create a column which lists numbers consecutively from 1 - 10,000, grouped in intervals of 20 (ex: 1 - 20, 21 - 40, 41 - 60, 61 - 80, ...) without having to enter them all manually. Is there anyway to do this in Excel?

View 3 Replies View RelatedI have the attached table of numbers and I need a formula at the end of each column to identify whether any cells in that column consecutively have numbers in them greater than zero. Ideally by a count of how many cells in the column have consecutive numbers greater than zero (so if there are three 1's in a row and then a zero and then another 2 1's I want it to count 5).Excel Help.xlsx

View 2 Replies View RelatedE20 with the series of numbers in tenth, and with five numbers on one cell. Between 01-37. How do I write a formula on column R to identify any repeated numbers from E20 with E21? In the chart it shows number 10 is repeated from E21, so I place a check mark on the same row as E20 on column R.

On column S how do I write a formula to identify numbers within E20 to see if there are any consecutive numbers? On E20 there is none, on E21 there is one 10-11, and column S will let me know if there is a consecutive by placing a check mark.

I am working on two worksheets. On my first worksheet I have one column with consecutive numbering starting from Cell 8.

A8 = 1

A9 = 2

A10 = 3

A11 = 4

A12 = 5

On my second worksheet I want to link to the values in the first worksheet but not in a consecutive manner. Each number will have an interval of 15 cells. As shown below:

D15 = 'link on Sheet1!A8'

D30 = 'link on Sheet1!A9'

D45 = 'link on Sheet1!A10'

D60 = 'link on Sheet1!A11'

D75 = 'link on Sheet1!A12'

I am trying to write a macro for transposing one row into multiple columns where the starting point for each column will be 15 cells starting from B4. I want to replicate the transpose for 200 rows.

View 4 Replies View RelatedHow do i change my data file from 1' intervals to 5' intervals?

The way it is now The way I need it

8300 8300

8301 8305

8302 8310

8303

8304

8305

8306

8307

8308

8309

8310

thru 11,000

My sheet consists of the following Data in the table ( to be increased to 99 rows or events )

I need to find the Next Date Occurence till the End_date

Next_Date1 = Start_date + Interval

Next_Date2 = Next_date1 + Interval

and so on till Next_Datexx is greater than End_date

I need a VBA code to fill the adjacent columns ie Next_date1 to Next_Date99 ( till the end_date), only if the Status is "DONE". If the Status is blank then the relevant colums must not fill.

I can do it with formulas, but need the VBA code.

Also the number of rows can be increased to 99 rows

Event

Start_date

End_date

Interval

[Code].....

I'm trying to make a histogram with the data analysis tool. The problem is that whenever I make a chart it doesnt show my intervals correctly. It puts them under the bars instead of between them.

View 3 Replies View RelatedI'm making use of a histogram to visualize my data. The only problem is that 90% of the data has a value which lies close to eachother but 10% is very different.

For example:

Interval-----Frequency

0-10------5

10-20-----7

20-30-----6

30-40-----0

40-50-----0

50-60-----0

60-70-----0

70-80-----0

80-90-----0

90-100----0

100-110---2

Now the histogram I will obtain won't look very good. Is there a way I can have an interval like 40 - ... which resembles everything above 40?

I'm trying to determine how much time our agents are spending for their lunch/breaks during 30 minute intervals. Range A8:A200 lists the agent's names, Range B8:B200 lists their lunch/break start times, Range C8:C200 lists their lunch/break end times, and Column E lists the times (8:00, 8:30, 9:00, etc.). If an agent starts their break at 10:57 (Column B) and ends at 11:10 (Column C), the value next to 10:30 (Column E) would have 0:03:00 and the value next to 11:00 would have 0:10:00. But would need to sum all the agents which took a break/lunch between 10:30-11:00, and 11:00-11:30.

View 2 Replies View RelatedI think I've had enough of using excel generated macro's as an excuse for decent code. I need to turn this:

Small procedure, function, what have you that will continue this pattern until I hit some kind of indicator to tell it to stop. This just clears the contents from 7 rows, hops down 9 rows and does it again.

I have posted earlier thread on similar problem but i did not get much response.I am really having a tough time to record a macro, where my columns will be selected with an interval and then will be pasted in to another sheet....

View 6 Replies View RelatedI would like to write a formula to average cells F27 - F11007 in a spreadsheet for every 96 values. That is, I want the average of F27:F122, F123:F218, F219:F314 and so on up to F10912:F11007. Ideally I would be able to pull down the fill handle and perpetuate the formula since this is a lot of data.

I've been trying to use INDIRECT and OFFSET formulas but I get a #REF! or #VALUE error.

Below is the code i want to be run evey 2 minutes Thanks

Sub WebData()

Dim wSU As Worksheet

Dim wSR As Worksheet

Dim wSS As Worksheet

Dim iForRow As Integer

Dim iLastRow As Integer

Dim sURL As String

08:00 26calls

12:00 50calls

16:30 16calls

The problem is the data is output as above just outputing intervals with data.

I need to convert this data to 15 minute intervals as below:

08:00 13calls

08:15 13calls

12:00 25calls

12:30 25calls

16:30 8calls

16:45 8calls

Does Solver provide confidence intervals around its parameter estimates?

View 9 Replies View RelatedI have a range, intervals and need to find out how many observations are in those intervals...

RANGEINTERVALFREQUENCE-0.10773-0.10773-0.11 ?-0.10144-0.11 -0.05 -0.0983-0.05 0.01 -0.085110.01 0.07 -0.0810.07 0.13 -0.078760.13 0.19 -0.07580.19 0.25 -0.071360.25 0.31 -0.070750.31 0.37 -0.06930.37 0.43 -0.068420.43 0.49 -0.068060.49 0.55 -0.067390.55 0.61 -0.060030.61 0.67 -0.059350.67 0.73 -0.057470.73 0.79 -0.05290.79 0.85 -0.052570.85 0.91 -0.05190.91 0.97 -0.051340.97 1.03 -0.050011.03 1.09 -0.048051.09 1.15 -0.046941.15 1.21 -0.046411.21 1.27 -0.045311.27 1.33 -0.045291.33 1.39 -0.045061.39 1.45 -0.045021.45 1.51 -0.044341.51 1.57 -0.043321.57 1.63 -0.042231.63 1.69 -0.041661.69 1.75 -0.041441.75 1.81 -0.040051.81 1.87 -0.038661.87 1.93 -0.038561.93 1.99 -0.037811.99 2.05 -0.037112.05 2.11 -0.036272.11 2.17 -0.033292.17 2.23 -0.032872.23 2.29 -0.032672.29 2.35 -0.031322.35 2.41 -0.029372.41 2.47 -0.029262.47 2.53 -0.028292.53 2.59 -0.028222.59 2.65

I am trying to do is calculate (sum) results data for time intervals. For example, between 0500-0559hrs then 0600-0659hrs and so on. Data is collected at 1 minute intervals and may have a result of 0 or anywhere up to 30.

Column A has all time data e.g. 0500,0501,0502 etc

Column B has sum of instances e.g. 0,1,2,3 etc

I want to create 15 minute time intervals from the data. I attached the file for reference. I would like to sum the data column that corresponds to each interval. I created an example using the formulas and I want to be able to do that automatically either using VBA or the formulas.

View 5 Replies View RelatedI want to set something up so the following text, is repeated at set intervals down the sheet, a number of times defined by an integer input box at the top of the sheet. Next to each new text array, I'd like to define a dynamic name range, calling each an increment above the one before. So:

Question Title

Question no.

Assessment Target

Level

No. of Marks

With name ranges being, (for e.g.) P1QT, P2QT, P3QT. For three sets of papers for the "Question Title" range.

Count the number of occurences on 1 day within a 60 minute timeframe. data includes dates and times

View 5 Replies View RelatedI've been working on this for days, i still got no solution on what formulas I will put on cells in "To" tab. The excel file is composed of two tabs "To" and "From". We will convert the "From Tab" to "To" format. What formula will I put in D3 to V3 and drag down in "To" tab to convert datas from "From" tab.

View 9 Replies View RelatedI'm using Excel 2007 and I want to plot data vs dates. Furthermore I want the dates on the dates axis to increment by month not by a certain number of days. So something like this:

1-Jan-09

1-Feb-09

1-Mar-09

...

There's the Major/Minor Units on the Axis Options screen but I cannot type in a constant number since the number of days for each month is different.

I have been given the task of finding out who logs in at what time of the day.

I have attached the raw data that I have to work with.

In essence I need to see how many login's there were for 06.00 - 10.00 at 15 minute intervals e.g:

06:00 - 5 Logins

06:15 - 1 Logins

06:30 - 3 Logins

06:45 - 11 Logins

etc

Has anyone got any suggestions?

I'm the Held desk manager . I'll have my folks logging in every time interval and work for 9hrs. Now I wanted to see at any given point a day the number of folks I have on my desk .

I have created table " A " and I'm looking for a formulae so that I get my data like table " B " .

To give more insight about table '" B " - During 00:00 - 00:30 , I'll have 41 people slowly goes down as people log off..

In the attached excel file I'd like to use data that was polled every 15 minutes. i.e 00:15, 00:30, 00:45, etc. Can I do this without having to manually delete all the nonrequired data per each row?

Also I have many files of such data that and would like to combine the all them into one to represent data for the whole year polled at every 15 minutes.

I have to write the word "hyllvagn" in column A in every fifth row starting with $A$2.

The range should be $A$2:$A$100.

i have a s/sheet with thousands of times in a column (eg col1 below in 24 hour format) and would like these in an adjacent column in hourly intervals (eg in Col2 below

e.g.

Col1 ColB

00:23 0 - 1

02:54 2 - 3

09:07 9 - 10

15:24 15 - 16

Is there a formula I can run to enable?

30 days

03/24/14

I am trying to add 30 days to the above date . I want to leave the days because I'm calculating intervals.How can I do this?

Copyrights 2005-15 www.BigResource.com, All rights reserved