Hello everyone and i hope i you can help me with my problem.
I'll try to keep it simple. So let's do this!
I got 2 columns lets call them A and B.
A
is almost always an 8digit number maybe less but never more like 12345678
or
is with a letter like 123w4567
B
is always checking the 3rd and 4th digit of A column and shows a sentence for example
A column number is 12305544 so the 3rd and 4th is 30 so in column B i type CR15
i want that to be automatic. But now comes the real problem i got around 50 codes like 30=CR15, 90=CR20 and goes on.
What can i do???
Bookmarks