79259582

Date: 2024-12-06 22:58:58
Score: 0.5
Natty:
Report link

Shorter formulas:

enter image description here

[E2]=LET(a,A2:A16,b,B2:B16,f,FILTER(b,a=H1),FILTER(B2:C16,(a=E1)*XLOOKUP(b,f,ISNA(f),TRUE)))
[H2]=LET(a,A2:A16,b,B2:B16,f,FILTER(b,a=E1),FILTER(B2:C16,(a=H1)*XLOOKUP(b,f,ISNA(f),TRUE)))
Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
  • Has no white space (0.5):
  • High reputation (-1):
Posted by: rotabor