6 Replies Latest reply: Nov 5, 2014 7:49 AM by Puttemans Johan RSS

    How to exluding one value in apply Map

      Hi Friends,


      I am using apply map function to recognise the sales type.


      I have use three columns x ,y, z to identify which sales type it is.


      So  X Y Z

            1 2 1

             2 1 3

             4 5 7


      The problem is the combinations of X and Y are less. But the Z can take any value excluding ZERO (0).


      So How to exclude 0 from my z value. Should I write all the values for z also. there are hundred in Numbers.