Forum Discussion
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...
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.