Forum Discussion

craig811's avatar
craig811
Icon for Helper III rankHelper III
7 years ago

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...
Need Help
PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

craig811 Please provide some sample test data and expected output to provide an accurate solution.

craig811's avatar
craig811
Icon for Helper III rankHelper III
7 years ago

Could I use the 'Earlier' function with the IF statement to look and the entire column for a match instead of looking at just the current row?