2 Replies Latest reply on Jan 25, 2017 2:59 PM by Yingying Zeng

    conditional filter  for the number started with 00

    Yingying Zeng

      Hello,

       

      I have a bunch of the code ( the first column in the attached excel sheet) and want to the filter only the number starting with 00. It is very clumsy to find all the  value manually and can not  use the contain function as well since it will also include the 00 which is not in the first two digit of the number.

       

      Is there any way we can automatically to get all the number start with 00( the first two digit) and filter only these numbers.

       

      Thanks a lot,

      Erina