7 Replies Latest reply: Aug 13, 2014 6:54 AM by Michael Tarallo RSS

    Load values in a column if not equal to

      I have some values(lets say red, blue, green, orange, black, yellow, (blank) ) in column A.


      How can I load column A with only red, blue, and yellow?

      I am able to do


      if(A<> red, A)


      How can I add multiple values and add the blank as well?


      Thank you in advance


      (Don't have access to "Discussion Forums")