Jan 12 2021 01:55 PM
Jan 12 2021 03:52 PM
The sort of formulas that might help are
= COUNTIFS(values, values)
and compare with
= COUNTIFS(values,-values)
If you use MS365 then you can filter the numbers and compare the count of positives and negatives
= COUNTIFS(values, UNIQUE(ABS(values)))
and
= COUNTIFS(values,-UNIQUE(ABS(values)))
Jan 13 2021 02:47 AM
If with conditional formatting may apply the rule as
with formula
=SUM(--(C2=-$C$2:$C$18))
Jan 15 2021 12:00 PM
Jan 15 2021 12:52 PM
SolutionIt could be
=SUM(--(C2=-$C$2:$C$18))*IF(C2>0,COUNTIF($C$2:$C2,C2)=1,1)
which highlight only FIRST met positive number and ALL symmetric negative numbers for each pair. If only first negative is needed, when instead of IF use only COUYNTIF within it.
Jan 15 2021 01:30 PM
Jan 15 2021 12:52 PM
SolutionIt could be
=SUM(--(C2=-$C$2:$C$18))*IF(C2>0,COUNTIF($C$2:$C2,C2)=1,1)
which highlight only FIRST met positive number and ALL symmetric negative numbers for each pair. If only first negative is needed, when instead of IF use only COUYNTIF within it.