Data validation special case (alphanumeric ascending order)

Originally Posted by Glenn Kennedy

I don't understand what you're asking and I don't see anything duplicated in your list.

Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Clarifying:
A stands for customer. Customer is placing an order

XX stands for sequence in year, from A0115 to AXX15

The year-last 2 digits is (will be) year 2015- approx. 2025 (YY)

1. User need a reminder/stop if registering same sequence twice in a year:
Example - user inputs A1215 on row 50 which should be A2515

2. Note: there are blank rows in the table columns, these should be ignored.
(An order may contain several rows of article details, should be of no concern here.)

Of course, if this problem were solved, the next would be:

1. User needs a reminder if out of year sequence:
Example – user inputs A1215 on row 100 which should be A2516

2. ?

To sum up:
We have a table where the user must register in an OrderID column a continuous sequence from A0115..to AXXYY, and needs a warning/stop if anything is repeated.
Reminder:
“A” indicates the customer
“XX indicates the customer’s new order, next in sequence
“YY” indicates the year, next in sequence when order placed in new year
The series to be controlled will then look like this example:

A0115…..AXX15
A0116… .AXX16
etc
A0125…..AXX2X

Enjoy?
Torers

Brilliantly simple