79270006

Date: 2024-12-10 22:44:51
Score: 1.5
Natty:
Report link

You can return the row and column reference, and subtract 1 to account for the title row / column.

For X use;

=SUMPRODUCT(($B$2:$K$11=O2)*(COLUMN($B$2:$K$11)-1))

And Y;

=SUMPRODUCT(($B$2:$K$11=O2)*(ROW($B$2:$K$11)-1))

enter image description here

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: liver