sequential

hi all... how to sequential numbering like this : 1 1 2 2 3 3 etc.. any help...thanks so much m.susanto

I've created a query to return all values in a table where 'Type' is 'A' <tbody> Type TypeNumber A 34 A 35 A 36 A 37 A 45 A [XXX] A [YYY] A [ZZZ] </tbody> Can update queries update the blank 'TypeNumber' fields in sequential order based on the record above it? E.g.: 'XXX' =...

Hello, I need to add sequential numbers in column AX based on the change invalues in column BC. Column BC is already sorted so all like values are together. The data in column AX starts at cell AX5. Is it possible to create a vba code that will add sequential numbersbased on the changes in...

Just recently upgraded to Excel 2016. I've noticed that when I open up a new instance of Excel, the default Book# file name will be sequential compared to it using the lowest book# based on what is already open For example when if I have no open Excel files and I open up a new instance, it...

I've used VBA before for something similar, but that was when I had some helper tables. Not sure where to begin with this one. Basically for each range, I need to assign a sequential number to the range, and then I need to assign a sequential number to each row within the range. Here's what...

than are allowed in the current file format." All I'm trying to do is add quite a few cells (around 100) that are not in sequential order and I keep getting this error message. What am I doing wrong? Or, how do I fix this? Thank you, to anyone who can help me!

I have random cells within (A1:Z25) that equal the letter "A". I would like a Macro to find every cell that equals "A" and replace the "A's" with sequential numbers starting with 1 then 2 then 3 and so on.

Hi All, I need to a macro that will sequential date my worksheets with text and then a sequential number at the end. i.e 06/01/18Page1, 07/01/18page2, 08/01/18Page3, 09/01/18Page4........ I probably be need to to end of year Also, at the same time i need sheet2 from my workbook to be copied...

i am working on a form that is to generate a number based on two parts (ie 5600) where 56 is select from a list and then 00 is to be a sequential number starting at 00 when the 56 is selected and the second part is added i need the 00 the step up 1 if the number exists, this is so we dont get...

Thanks for any help on this - I appreciate the gift of time and knowledge that so many on this forum freely give :) I have an Excel Table named "tbl_Schedule" The first column is named "Counting" The Counting column's purpose to start with 1 and count sequentially all the way down the table...

Hello, I have data that is in sequential order. One column contains data that is either 1 or 0. I want to create a new column that numbers the groups of consecutive 1's. <tbody> 1 1 1 1 0 0 1 2 1 2 1 2 0 1 3 1 3 0 0 0 1 4 1 4 </tbody> What is the best way to...

Hello Magical Excel Guru's! I am trying to determine if there is a way that I can use either a formula or vba to auto assign sequential numbering based on text. Basically we have the united states split into 5 zones. There are multiple states in each zone. Each customer will be assign a site...

Hi everyone, I am looking to produce a macro that will enable me to do the following: Copy a selection of cells, for instance [A6:D6] Insert the same row; in terms of formatting and row height into [A7:D7] However, cell A6, contains the following data "a.1" and when the macro is run, cell A7...

Hi, I am creating a master register for internal business documents, each shall have their own unique document number. I have a dropdown for cells under DIV and DOC, with list parameters on separate datasheet. I have a partial formula within DOCUMENT NUMBER column of =($A2&"-"&$B2&"-"&$C2)...

I already have a macro created for my worksheet where a keyboard short cut of "Ctrl+T" generates the next "ticket number" by adding 1 to the last number. For example, if the ticket number in Column C, Row 4 is 10902 then I would click Column C, Row 5 and press "Ctrl+T" shortcut and the ticket...

Hello, I need to place a simple sequential number in a cell, I searched a lot but couldn't find something as simple as I need: Cells(emptyRow, 2).Value = ???? Thanks!

Hi all, I have searched through the forum for something in VBA to accomplish this... but, so far no luck. I don't remember near enough of my VBA classes to dig myself out of this one. (I volunteered to get this done...) What I need is a worksheet that I can open, click a button that generates...

Hi, Andrew recently gave me a hand with an Excel formula I had been working on to automatically construct an SCCM collection query from a list of computer names entered in column B of an Excel 2010 spreadsheet (found this thread here...

Good day, I have a question: I work at a phone retail shop, and we use Excel to make the receipts for our customers. In order to find the receipts back if there's a problem, we have to (manually!) increase a number, the order number, everytime we open the file. So, one customer comes, buys...

I am trying to match two cells and put a unique number next to it. I have managed to recognize the two requirements and not fill the other cells unnecessarily but my equation will only output 1 and I cannot get it to add one to the previous cell that has a number, to end up with 2,3...