79782920

Date: 2025-10-05 10:32:44
Score: 1
Natty:
Report link

With Candidates in A2:A6 and Rankings in B2:B6, why not simply create the 5x5 matrix in C1 with the simple formula below? Obviously, you can exchange the cell references with dynamic or named ranges, but there is no need for LET, LAMBDA, TOCOL, MAKEARRAY etc.

=VSTACK(
    TRANSPOSE(A2:A6),
    --(TRANSPOSE(B2:B6) < B2:B6)
)
Reasons:
  • Has code block (-0.5):
  • Contains question mark (0.5):
  • Low reputation (1):
Posted by: R vE