E-Mail 'Create number series' To A Friend
Email a copy of 'Create number series' to a friend
Loading ... Loading ...12 Responses to “Create number series”
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
I have tried using the "Create a number sequence to count individual products" formula but when I copy it down it moves the second $ to before the first number. I would like to know if there is anyway of stopping this from happening
Paul,
I don´t think I understand:
when I copy it down it moves the second $ to before the first number
=SUMPRODUCT(--(A52:$A$52=A52))
May be you want something like this
=COUNTIF($A$52:A52,A52)
Does (=SUMPRODUCT(--(TEXT($A$64:A64, "yyyy")&(B64:$B$64)=YEAR(A64)&B64)) + Enter) work for months
Erik Reppert,
What are you trying to calculate? Can you provide some example data?
in terms of the one of re-starting the sequence when a cell value equals a certain criterion, how about continuing the sequence by ignoring that same criterion?
so, in the case of A, B, D, D, C, B, D, A
the sequence will be if we ignore all the Ds: 1, 2, 0, 0, 3, 4, 0, 5
I'm trying to add to a hyphenated range. The sequence consists of two numbers in one cell for shipping labels, and it almost always has 40 added to each of the two numbers in it (because 40 small cartons fit in the larger shipping box).
Example: Cell B2 would read "MAB0053850-MAB0053889"
Cell B3 would read "MAB0053890-MAB0053929" and so on
The "C" column cells just have one sequence that's assigned to the larger shipping box, which contains the 40 "MAB..." cartons next to it.
Any way I can create a formula to extend these sequences vertically without splitting the two numbers into separate cells? Any help is appreciated. Thank you!
i have a serious problem..
i want to make a check voucher using excel 2007.. the problem is;i don't know how to series the check no. in the next voucher that follows.. in 1 sheet i format it into 2 voucher..
I made a template about “Insertion Sequence Numbers Automatic with Macro Codes”. You can add the sequence numbers to column that you want with your msgbox answering.
https://www.youtube.com/watch?v=hsQsW26nbNo
You can get it Here : https://netmerkez.wordpress.com/2015/08/23/insert-sequence-numbers-quickly-with-codes/
I have account numbers in COLUMN A, Status in COLUMN B, and dates mm/dd/yy in COLUMN C. I have multiple line items that apply to the same account number in COLUMN A. The Status for each line item can be 1, 2, 8-1, or 9-1 in COLUMN B and the date of each line item in COLUMN C. My goal is to have a sequence of 8-1's by date. I need to create a sequence of each orders 8-1's and a sequence of orders for 9-1's. That way when they sort on an order number (Account) they can get the sequence of updates. Ive tried Countif, Countifs, if(countif(, if(countifs... and I can get counts but they wont go in seq order of date. Ive tried to countif the date is <= date in CELL Cxx but no love.
Status Nomen
1 means created order.
8-1 means applied a change to order (can have multiple changes).
2 means order approved with updates.
9-1 means had a approved update after the approval (can have multiple updates after approval).
count Account_Number Status mm/dd/yy Seq needed
1 rt25hg62 1 1/1/17 1
2 dr87jh56 1 1/6/17 1
3 df12hg35 1 1/11/17 1
2 dr87jh56 8-1 1/26/17 1
4 er55tv16 1 2/15/17 1
1 rt25hg62 8-1 3/1/17 1
2 dr87jh56 2 3/2/17 1
3 df12hg35 8-1 3/12/17 1
1 rt25hg62 8-1 4/1/17 2
5 ww15hr26 1 4/3/17 1
5 ww15hr26 8-1 4/9/17 1
6 st45yu66 1 4/14/17 1
1 rt25hg62 8-1 4/15/17 3
4 er55tv16 8-1 4/17/17 1
2 dr87jh56 9-1 4/20/17 1
1 rt25hg62 2 4/22/17 1
3 df12hg35 8-1 4/27/17 2
3 df12hg35 8-1 5/1/17 3
3 df12hg35 2 5/5/17 1
4 er55tv16 8-1 5/7/17 2
6 st45yu66 8-1 5/8/17 1
4 er55tv16 8-1 5/9/17 3
1 rt25hg62 9-1 5/12/17 1
5 ww15hr26 8-1 5/16/17 2
3 df12hg35 9-1 5/18/17 1
1 rt25hg62 2 5/20/17 1
6 st45yu66 8-1 5/21/17 2
4 er55tv16 8-1 5/22/17 4
6 st45yu66 2 5/23/17 1
6 st45yu66 9-1 5/24/17 1
4 er55tv16 2 5/26/17 1
1 rt25hg62 9-1 5/27/17 2
4 er55tv16 9-1 6/1/17 1
5 ww15hr26 2 6/9/17 1
Hello,
how do you create from this:
SKU123,2003-2006
SKU345,2000-2001
SKU678,1999-2004
this
SKU123,2003,
SKU123,2004,
SKU123,2005,
SKU123,2006,
SKU345,2000,
SKU345,2001,
SKU678,1999,
SKU678,2000,
SKU678,2001,
SKU678,2002,
SKU678,2003,
SKU678,2004
please let me know.
Hello,
how we can create like this in excel:
201-212
215-221
from
201,
202,
203,
204,
205,
206,
207,
208,
209,
210,
211,
212,
215,
216,
217,
218,
219,
220,
221
please let me know.