View Single Post
  #5   Report Post  
Spencer101 Spencer101 is offline
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by DamienPham View Post
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?