I am able to understand the above conversion of excel function to Knime math formula. However, I am having trouble in converting the following formula:
=IF(COUNTIF($F$2:$F$61706,F2)=1,FALSE,NOT(COUNTIF($F$2:F2,F2)=1))
This formula returns false if a string occurs first time in a column (here column F) and true if the string occurs second time. Cells with False are unique strings.
Maybe I’m mistaken but not sure how this formula can return TRUE unless column is empty
Anyways Rule engine node should do it but you would need to count the number of times string occurs before it and pass it as a flow variable to Rule engine node.