1. P

    Assign the Same Sequential Numbers to Duplicates

    I'm using Excel 2007. I'm trying to reacreate the pattern shown in the sequence column. Could someone please give me a pointer as to how I could do this?
  2. Q

    Help with sequential numbering

    Hi there everyone I'm new here and come here to find some help about a problem that seems easy to solve but i can't do it. It has 2 parts this problem The first one is i need a solution to automatically fill in the serial number column (column C) sequentialy and acordding to column A (example...
  3. L

    Duplicate Timestamps & Creation of Unique Reference Number based on Loads

    Good Afternoon, I am having some issues with a dataset that came from an outdated system our business used before I joined, they had recently moved to a new system when I joined and now I can see why! The data below relates to Customer Journeys, which lack a vehicle identifiable field (which...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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?
  10. 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>
  11. 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...
  12. 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...
  13. 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?
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back