# Identify All Consecutive Intervals

Sep 18, 2013

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

## List Consecutive Numbers From 1 - 10000 In Intervals Of 20

Feb 28, 2014

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?

## Identify Consecutive Numbers Greater Than Zero

Jan 14, 2014

I 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

## Identify Repeated And Consecutive Number

May 5, 2009

E20 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.

## Use Data From Consecutive Rows Into Non-consecutive Rows On Different Worksheet

Feb 26, 2013

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:

## Transpose One Row With Intervals

Mar 21, 2009

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.

## Change The Intervals

Jul 9, 2008

How 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

## Getting Date At Specified Intervals?

Feb 12, 2013

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].....

## Histogram: Intervals Below Bar

Oct 5, 2006

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.

## Histogram Intervals

Oct 6, 2006

I'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?

## Sum Times During Multiple Intervals?

Mar 18, 2014

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.

## VBA To Clear Contents At Specified Intervals

Mar 6, 2014

I 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.

## Rearranging Columns With Intervals

Aug 16, 2009

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....

## Averages With Jumping Intervals?

Jul 18, 2013

I 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.

## Getting A Macro To Run On Time Intervals

Dec 7, 2007

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

## 1/2 Hour Intervals To 15 Minutes

Sep 26, 2008

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

## Solver: Confidence Intervals

May 7, 2009

Does Solver provide confidence intervals around its parameter estimates?

## Find Out How Many Observations Are In Those Intervals

Aug 9, 2009

I 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

## Sum Data For Time Intervals

Oct 10, 2009

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

## Creating 15 Min Intervals From Data

May 4, 2007

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.

## Repeat Text At Specified Intervals

Aug 26, 2007

I 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.

## Countifs Date And Time Intervals?

May 26, 2014

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

## Transposing From Horizontal To Vertical With Intervals

Jan 9, 2014

I'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.

## Chart Axis Date Intervals

Feb 20, 2009

I'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.

May 12, 2009

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:

etc

Has anyone got any suggestions?

## Returning A Value If The Time Falls Between Two Intervals

Nov 7, 2009

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..

## Sorting Data To 15 Minute Intervals?

Jan 11, 2014

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.

## Excel - Write A Certain Word With Intervals

May 15, 2014

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.

## Convert Times Into Hourly Intervals

Sep 26, 2013

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?

## Formula With Text - Calculating Intervals

Mar 25, 2014

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?