2 Replies Latest reply on Feb 6, 2018 9:26 PM by Zhouyi Zhang

    Check for value in other column

    Martin Nørby

      Hi

      Is it possible to do a calculation that checks if a value in eg. column B exists in column C (maybe in another row) and returns 1 if true or 0 if false.

      Example:

      Kind regards Martin