2 Replies Latest reply: May 15, 2014 9:58 AM by BaWahoo _ RSS

    display one column if it does not match another

    BaWahoo _

      Is there a way to create a formula to display one column if it does not match another?  I want to display the COL1 if it does not match COL2. So in the sample below, APT 3 should be displayed.

       

      How do I code: IF Substr(COL1,1,5)<>Substr(COL2,1,5) THEN DISPLAY COL1

       

       

      COL1     COL2

      BAYTO     BAYTO

      BAYTO     BAYTO

      APT 3     DALLA

      EAGLE     EAGLE

      RICHM     RICHM