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.
code number (as text) desired result date condition cost ($)
1 31/12/2000 1 5
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 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 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 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 ...
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
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?