Quote:
Originally Posted by DamienPham
Excel 2010.
|
Sorry for all the questions, but the explanation was slightly bereft of detail.
So you're looking for Type 1 if the last 6 digits contain 256 and Type 2 if the last 6 digits contain 786. What happens if neither appear in the last 6 digits?
Also, are there values for Type 3, Type 4 etc or just the 2 types?