• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. K

    Wildcard

    Alternatively, I tried to group all the stock ID that has alphabets as below =IF(OR(RIGHT(V2,1)="1",RIGHT(V2,2)="AP","SH","MG","etc",etc),1,2) That didn't work too.
  2. K

    Wildcard

    Thanks Narayan. But that's what I don't want to do. It's a very long list. There must be a way to put a wildcard so that any stock ID that ends with an alphabet can be changed to value 1. Any other ways?
  3. K

    Wildcard

    Dear all, how to shorten this formula? =IF(OR(RIGHT(V2,1)="1",RIGHT(V2,2)="1N",RIGHT(V2,2)="AP",RIGHT(V2,2)="SH",RIGHT(V2,2)="MG"),1,2) As you see, I am trying to put a value of 1 to any stock ID where the last 2 count from the right are any alphabets. There are many stock IDs with...
Back
Top