Forum Discussion
Help with formula
Hi , A member of the forum, kindly provided me the following forumla:Column = IF(ISERROR(FIND(LEFT([Transaction Number],FIND("-",[Transaction Number])-1),[Line Description])),0,1) However , h...
craig811 Please provide some sample test data and expected output to provide an accurate solution.
Thank you for the reply :
Please see the below:
As you can see W1173778 is in colunm 'Line Description' but on a different row then colunm' Transaction Number' . The formula above will not pick this up and will show '0' instead of '1' for match.