Converting EXCEL formula into Alteryx expression/workflow

Question

Hi,

Read a lot of posts here on the community but not got to a solution for my issue.

Can you help convert the following EXCEL formula into Alteryx Expression?

=IF(COUNTIF($A$2:A3,A3)<=MIN(COUNTIF($A:$A,A3),COUNTIF($A:$A,-A3)),"Storno","Not Storno")

Thank you!

formula storno.xlsx

uips · Accepted Answer

Hi,

That is exactly right. The idea is to identify and eliminate numbers that
are the same but with negative and positive signs. If there are 2 values
of +100 and 2 values of -100 all 4 need to be called "Storno".

Moreover, if there are 3 values: -100, +100, +100, only one positive +100
should be called "Not storno" and the other 2 values should be
called "Storno"