unique number

  1. S

    Creating New PO#s in a Table

    I'm taking over a spreadsheet made by someone else. The person is not contactable for assistance. I have a table that spans from A4:W514 and is called "CheckbookTable". I need a macro to create a new line in the table, but each new line needs to have a new and unique PO# in column L as well as...
  2. M

    Generate Unique number for data with certain criteria

    Hello Everyone, I have a sheet and I want to give certain rows a unique number, so when I delete those rows, the number will not be used again. I want to give every row where Column B is the same and Column D is the same and Column L is the same, the same number, so like this: <tbody> Column...
  3. W

    I have two sheets in Excel that both contain data and would like to merge data.

    Hi Guys, I have two sheets in Excel that both contain data. Both pages have a unique column which is labeled 'ItemNumber'. This runs from 100000 through to 106144. Apart from this column, both sheets have different columns with different data. I would consider the 'ItemNumber' to be the unique...
  4. L

    Conditional format non zero unique

    I have a multi-column 4 row table with zero or positive values. In each column I want to highlight the lowest non zero value if it is unique - not quite the same as the lowest unique value, which may not be the lowest value! So must be a Conditional Format formula I am relatively new to Excel...
  5. A

    Generating Sequential Order Numbers

    Greetings oh enlightened Excel Professionals! I humbly seek advice over a number of little issues... I have looked thru a number of the threads and answers already on this site but I do not see anything similar to what I am going to ask you. I want to develop an ordering system for my...
  6. S

    Giving a form a unique ID number

    I have created a form that when printed will be used as a rejection tag for isolating damaged or on-hold parts. Each tag that is printed must have a unique ID number. Is there a way to have excel automatically populate a field, giving each saved/printed tag a unique ID? For example, I open...
  7. A

    Tough question from my friends - Need your help

    Hello All- My friend consulted me a certain task in excel but could not figure out correctly. Here are the requirement; He has the first sheet HERE and here is the input; 1. In column Z, he want to input the machine number 1,2,3,4, etc 2. In column AA, he want to input the sequence number as...

Watch MrExcel Video

This Week's Hot Topics

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 MrExcel.com.
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 "mrexcel.com".
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
Top