Forum Discussion
vaidation for the serial number
Here I am attached my worksheet
Hia,
i've attached a copy of your workbook that has both a column that says Check Number if there is a missmatch and changes the colour, you can pick which you like more..
=IF(RIGHT(A4,MIN(LEN(A4),3))=RIGHT(G4,MIN(LEN(A4),3)),"","CheckNumber")
the formula is like this as not all of your numbers in the A column are 3 digits long, with this if they are smaller then it still works.
Hia,
i've attached a copy of your workbook that has both a column that says Check Number if there is a missmatch and changes the colour, you can pick which you like more..
=IF(RIGHT(A4,MIN(LEN(A4),3))=RIGHT(G4,MIN(LEN(A4),3)),"","CheckNumber")
the formula is like this as not all of your numbers in the A column are 3 digits long, with this if they are smaller then it still works.
