G Guest Apr 5, 2007 #1 I would like to filter in a column using 3 choices: ends with 1, 2 or 3. I cannot figure out how to add the third number
I would like to filter in a column using 3 choices: ends with 1, 2 or 3. I cannot figure out how to add the third number
D Dave Peterson Apr 6, 2007 #2 I add another column with a formula that evaluates the way I want: =or(right(A2,1)={"1","2","3","X"}) or =or(--right(a2,1)={1,2,3,9}) (if it's really a number) then I filter to see the TRUEs.
I add another column with a formula that evaluates the way I want: =or(right(A2,1)={"1","2","3","X"}) or =or(--right(a2,1)={1,2,3,9}) (if it's really a number) then I filter to see the TRUEs.