1. B

    How can I generate a list of codes in Excel based on criteria?

    I'm trying to make a list of codes based on a format of 001 A 001. They should be 001 to 062, A to E, 001 to 012. I need all combinations, so they would be: 001 A 001 001 A 002 to 001 A 012, then up to 001 E 012 Then 001 B 001 to 012, and so on until 001 E 001 to 012 Then 002, A to E, 001 to...
  2. V

    Data validation to prompt alpha numeric sequence

    Hello Is it possible to have a cell populate an alpha numeric sequence based on the selection from a data validation list? For example I was hoping to be able achieve - if someone selects “Design” from the drop down, this would cause the next cell to populate “DR134” and so on sequentially...
  3. zendog1960

    TextBox# issue

    I am creating a user form in which there are going to be 30+ textboxes. After copy pasting a few in, deleting a few, then adding more in, the numbering of these boxes are all over the place. I am doing a routine to populate these textboxes with values from a sheet within the workbook. I am...
  4. N

    Sequential Numbering Positive/Negative Amounts

    Hey all, I have column A containing positive and negative numbers and I am looking for a formula in column B for sequential numbering as follows col A col B 20 PS001 32 PS002 20 PS003 -20 NE001 10 PS004 20 PS005 -10 NE002 10...
  5. T

    Sequential Numbering in Rows Dependant on Other Inputs

    I'm having a massive problem getting an auto filling sequential number down a list of rows (column A). If one box has a value greater than 0 (column G)then I want to input a number (starting at 1). If one or several rows don't have this input I need that cell left blank, but need to keep the...
  6. R

    Selecting sequential numbers only

    Hi I was looking for a way of moving sequential numbers from Column A to Column B. I.E. If column A had numbers 1,3,6,8,9,10,11,12,15,17,19,20,21,24,28 Then numbers 9,10,11,12 and numbers 19,20,21 would be moved to the respective cell to the right in Column B?
  7. M

    sequential numbering

    I need to make make columns auto number in a certain order. Maybe someone can help <colgroup><col><col></colgroup><tbody> <colgroup><col><col></colgroup><tbody> F19130 F19130 F19130 F19130f F19131 F19131 F19131 F19131f </tbody> Can it be done? Thanks for any help </tbody>
  8. J

    Sequential Numbering Based on Data in Cells

    Hello, I am attempting to do the following and would appreciate any help: I have a spreadsheet that looks like the following <tbody> ABC ABC-001 DEF DEF-001 ABC ABC-002 ABC ABC-003 DEF DEF-002 </tbody> I manually enter in the information in the first column. In the second column, I...
  9. muhammad susanto

    Sequential Number Based On Given Number

    hi all.. how to make sequential number with parameter my target in column "interval" and "given" number as parameter (based on) like this layout : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial...
  10. G

    Sequential number printed on each purchase order printed?

    I have a worksheet that I created that is a blank purchase order for my organization. Someone prints multiple copies of the purchase order worksheet. Then the person has to write in a sequential number on each purchase order. Is there a way to have Excel number each purchase order?
  11. K

    New invoice using macro

    Hi, I have created a form in excel with invoice number which is alpha numeric. im having a hard time fixing the error about the leading zeros in my invoice number. My invoice number is FIN19-0001. i want to change it from FIN19-0001 to FIN19-0002, FIN19-0003 and so on. but every time i click...
  12. D

    Generate sequential number based on name

    Hi Excel Experts, Am trying to find a macro that auto-generate doc ref number sequentially (at the last 3 digits on the right) based on same student's name everytime I click a button. (numbers in the middle are generated randomly). Expected output : Name RefNum (cell A2) Darwin...
  13. T

    Countif and concatenate

    Hello, Looking to see if there's a way to combine COUNTIF and CONCATENATE formula. Column BB could have duplicates. In column BC, I'm using the formula "COUNTIF($BB$4:BB4,BB4" to give sequential # for dups. I created a column labeled UNIQUE DOC ID, to combine columns BB ad BC using the...
  14. P

    Increment a Text String

    Hi I have rows of data representing drawing numbers within various projects. Each row includes a Project Number in the format n.nn.n and a Sequential Number, format nnnn, within each of those projects. So you could have: 1.03.1 0001 1.03.1 0002 1.11.1 0001 etc I need to be able to calculate...
  15. A

    Sequential Numbering

    Hey guys. I am trying to write some code to do three things... 1. add a new row at the end of bottom of the sheet 2. copy all formulae with it 3. in column A, add Sequential Numbering I have sussed out the first two but the last one is killing me! to make it a tad more difficult for myself...
  16. N

    Sequential Number If

    Hi there. So I have a list of name of students. The list needs to remain in a specified order. But, I need to assign a sequential number to each student in a class. Looking for advice on how to do this. The list will never be more than a few hundred lines long. Again, I need the sort order to...
  17. T

    How to save files in date order eg 1 Sep, 2 Sep without doing them individually

    Hi I'd be thankful for any help. I am wanting to write 01/9/2018 in cell A1 then save it as 01/09/2018. I then want to open a new spreadsheet and write 02/09/2018 in cell A1 and save it as 02/09/2018 Then 3rd Sept etc all the way down to 30 September. Etc Etc. At the moment, i am having to do...
  18. muhammad susanto

    sequential numbering 1,1,2,2,3,3

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

    Access Update Query

    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' =...
  20. M

    Restarting Sequential Numbers

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

Some videos you may like

This Week's Hot Topics