If I want to create a column of numbers, say 1 2 3 4 5, I can simply add +1 to the previous cell and then use "fill down" to generate my number sequence. How would one generate a column of numbers that repeat once? e.g.: 1 1 2 2 3 3 4 4 5 5, etc

I'm trying to set up a worksheet so that when i enter a number in say cell J5 it will automatically create a new worksheet with the next number in order so if cell J5 was 1500 it would create a worksheet named 1501.

I have Excel 2003. I am trying to find the next number in a sequence of numbers. The number range is 1-59, and the sequence is 89 numbers that go like:

code number (as text) desired result date condition cost ($)

'1003

1 31/12/2000 1 5

[Code] ..........

if "code number", "date","condition" and "cost" the same line of rows so "desired result" = 1 like code "1003" or so code "1005" = 5, otherwise if there is a no match/same condition "desired result" start from = 2,3,4,etc.......

"A1" has a number containing "1000" I want column "B2" to choose the next number in sequence,(1001) so long as "A2" contains these letters "EHT". if it does not contain "EHT" i dont want excel to insert the number "1001" But if cell A3 contains, "EHT" I want the next number in sequence to be instered automatically... (1001, 1002, 1003")

I am trying to fill a column with a number series starting with 1 whenever a value changes in the adjacent column. So for instance I am trying to do something like this :

I'm trying to set up an auto sequence number(col A) based on a date entry (col B) as in the example below. The sequence number should reset to 0001 each time the date in Col B changes.

Col A Col B 072306-0001 07/23/06 072306-0002 07/23/06 072306-0003 07/23/06 072406-0001 07/24/06

I have a list of dates in column A as shown below & I want to get a count formula in column B for the # of dates in sequence. When the date sequence breaks a new count should be done at the end of the next sequence. The formula should be 1 I can put in cell B1 and copy down so that there are blanks & a count is only done at the end of the date sequence like in cell B4 or B7 below.

Col A Col B Date Count 1 12-Oct 2 13-Oct 3 14-Oct 4 15-Oct4 5 17-Oct 6 18-Oct 7 19-Oct3

I need to create a grouped sequence that changes every 10 rows.

So in Column A cell A2 the number would start at 01349 and every 10 cells it would decrease by 1 and go on down to 0 so it would look something like this:

I have in column AU cell 39 to cell 500 random sequences of 1-10 rows , with numbers in them, (as an result of formulas) I need to count the number of rows in each sequence that have numbers of 35 or less , but only up to the first number of 35 or higher. eg:-

I am trying to group the same values in columns together and i was thinking about having a number count. What's the function that might be able to display this (display whats in Column B in the example below)?

I have the following data: (The Dept can occur multiple times in Col B.)

Col A Col B Row 1

[Code]....

What I want to do I want to insert a formula in each row of Col A that returns a number that indicates if the Dept in Col B is the first occurrence of the Dept, the second occurrence of the Dept, etc.

I am trying to create a number counter which runs up to a value which is determined by a COUNTIF Statement in the spreadsheet. I can get the number counter to run to the given value. However, due do formatting reasons I do not want the counter to start in cell A1 but A3 instead.

Essentially my code looks like this: ... ActiveSheet.Cells(3, 1).Select Dim i As Integer For i = 1 To Range("A1") Cells(i, 1) = i Next i ...

This creates a sequential number column from 1-600. My problem lies when a new row is inserted, which is left blank. How can i maintain this auto function upon a new Row insertion?

I have a sheet with hundreds of rows of customer information; including a 7 digit customer number. I need a macro to delete all the rows where the customer number sequence start with 1 thru 8 (that would be the first digit of the customer numbers).

Windows 7, Excel 2007. a formula to find the next lowest sequential number within a group.

Here's an example data set, which represents transactions by date and category:

Col A is a user entered Date which will not be in chronological order (unfortunately a sort is not an option)Col B is a user entered CategoryCol C is a formula that gives the chronological sort order based on the date.

The formula in C2:C9 is =COUNT($A$2:$A$9)-(RANK(A2,$A$2:$A$9)+COUNTIF($A$2:A2,A2)-1)+1Col D is a formula to determine if the row is the first chronological transaction within the Category

The array formula in D2:D9 is =IF(MIN(IF($B$2:$B$9=B2,$C$2:$C$9))=C2,"Y","")

This might not be a necessary column, but can be used as a helperCol E is where I would like a formula to give the next lowest value in Col C for the Category in Col B (the order number in Col C for the previous transaction within the same category).

I have entered in the values that the formula should return in Col E in the table below

A B C D E

[Code]...

If the current line is the first transaction of the category, the formula should return the value in Col C for that line (so E2 would equal the value in C2, which is 2).

So the first part of the formula could be straightforward, using the helper column: =IF(D2="Y",C2,

Here's the tricky part: If it's not the first occurrence of the category, then it should return the value of Col C for previous transaction (or the next lowest number in Col C that is within the same category).

E3 would return 4, since the previous transaction for Category A was line 9 C3 = 6, and of all the values of Col C for Category A (2, 4, 6, 8), 4 is the next lowestE4 would return 6, since the previous transaction for Category A was line 3 C4 = 8, and of all the values of Col C for Category A (2, 4, 6, 8), 6 is the next lowestE5 would return 1, since it is the first transaction in Category BE6 would return 1, since the previous transaction for Category B was line 5 C6 = 5, and of all the values of Col C for Catebory B (1, 5, 7), 1 is the next lowestEtc.

I'm thinking I need an array formula to find the minimum value within the category, where that value is less than the value of Col C in the current line. Just not sure how to write that...

Column AH2:AH367 represents the current year and contains values from Jan 1 to Dec 31 inclusive, some of which are zero and future values are blank. Column AG2:AG367 represents last year and contains the same and all cells have a value (some are zero).

The date column is A2:A367 (the columns in between are all the years prior to 2013).

I need a formula that counts the total number of cells with a value greater than zero for the range AG2:AG367 up to and including today's date to be returned in cell A1 of Sheet 1.

see attached file. Need to find latest non blank value - in attached file it is highlighted in yellow. From there, want to summarise 26 weeks back so, in the attached file:

Row 2 would be finding 750 and summarised back 26 weeks from 30 sep 2012 Row 3 would be finding 2250 and summarised back 26 weeks from 2 dec 2012 Row 4 would be finding 5000 and summarised back 26 weeks from 4 nov 2012

I have a column of figures in a file sent to me recently which are dates but for some reason have been reversed eg 20140321. This is 21st march 2014. However I have tried formatting the number as a date (as we would normally see it in UK eg 21/03/14 or similar) and I cannot get Excel to recognise it as a date - I just get a long row of asterisks. How do I get a recognisable date sequence?