Forum Discussion
Sherwood_2022
Sep 11, 2022Copper Contributor
TRUE / FALSE result - ROW Duplication / Duplication in ROW
Hoping it doesn't seem too much of an ask, but I have two (2) requests for the one data set. The seven (7) columns has multiple ROWs with numbers in them that can't be sorted The numbers may vary i...
dscheikey
Sep 11, 2022Bronze Contributor
For your return 1, you need an auxiliary column in my solution. I used the following formula to assess whether the same numbers were used:
=(A2*B2*C2*D2*E2*F2*G2)+SUM(A2:G2)However, there are probably other functions from the statistics section, e.g.:
=HARMEAN(A2:G2)I'm not so sure about that, though.
Return 1:
=--(COUNTIF(J$2:J2,J2)<2)Return 2:
=--ISNA(MODE.SNGL(A2:G2))The whole thing is also in my attached document. I hope this helps you.