Hi,
I need any one help to create auto serial number as per the below conditions sheet is attached.
Column I5:I12000 – I Need to auto generated the serial numbers in “I5”
If there is item code, Job number, issue date if it is available based on that I need to apply the formulas,
If the job number and date is same then next serial number has to be generate automatically.
The Logic is
First condition: If “O” column having the item code, generate the serial number in "I5" starting number is like MIVS-0001 ( MIVS-) Is common for all. Like MIVS-0001,
Second condition: if there is no item code in "O"not to generate any serial numbers
Third condition: column number “J & M” “ Issue date & Job number ” is same within the date then generate the serial number same like MIVS-0001, If the date or Job number is different Generate the serial number as next MIVS-0002.
I Request you to please create formula or VBA without any errors with the conditions like N/A should be blank.
I need any one help to create auto serial number as per the below conditions sheet is attached.
Column I5:I12000 – I Need to auto generated the serial numbers in “I5”
If there is item code, Job number, issue date if it is available based on that I need to apply the formulas,
If the job number and date is same then next serial number has to be generate automatically.
The Logic is
First condition: If “O” column having the item code, generate the serial number in "I5" starting number is like MIVS-0001 ( MIVS-) Is common for all. Like MIVS-0001,
Second condition: if there is no item code in "O"not to generate any serial numbers
Third condition: column number “J & M” “ Issue date & Job number ” is same within the date then generate the serial number same like MIVS-0001, If the date or Job number is different Generate the serial number as next MIVS-0002.
I Request you to please create formula or VBA without any errors with the conditions like N/A should be blank.