automatic unique id number

Mitch90

New Member
Joined
Feb 7, 2025
Messages
1
Office Version
  1. 365
Platform
  1. Windows
when I create a new row it should get a unique number depending on the priority. for example if I select "1. High" under Priority the number should start with H followed by 4 digits. For "2. Medium" with M followed by 4 digits. and for "3. Low" with L followed by 4 digits. the workbook already sorts the rows automatically by priority and mechanic. when a point is processed it is automatically moved down. so the rows jump quite a bit. does anyone know how I can apply this? thanks in advance
 

Attachments

  • example.png
    example.png
    94.7 KB · Views: 4
Welcome to the Board!

I was going to say, you could use a formula, but that will probably not work if rows may be moving around, as the formula will be re-calculated every time the row is moved and won't be static.
If you want to create ID numbers that are unique and do not change, regardless of whether or not rows move around, you will need to enlist the use of VBA.
Are you agreeable to using a VBA solution (otherwise, I don't know how you are going to do this, if not manually)?

If so, can you answer this question. Are individual rows ever deleted, or only moved/added?
 
Last edited:
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,919
Members
453,767
Latest member
922aloose

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
Back
Top