79300487
Date: 2024-12-22 05:05:09
Score: 1.5
Natty:
Checks every row for duplicates, not just the first row:
=LET(
x, BYROW(A1:C4, CONCAT),
IF(MAX(SCAN(0, SEQUENCE(ROWS(x)), LAMBDA(a,v, SUM(N(INDEX(x, v) = TAKE(x, v)))))) > 1, "Dup", "No Dup")
)
Reasons:
Posted by: Bam - Probably link only (1):
- Low length (0.5):
- Has code block (-0.5):
- Low reputation (0.5):