79456553

Date: 2025-02-21 07:06:10
Score: 0.5
Natty:
Report link

The formula uses the REDUCE function in cell L23 and drag down.

=REDUCE(H23,H$23:H$31,LAMBDA(a,v,IF(ISERROR(VLOOKUP(a,H$23:I$31,2,FALSE)),a,VLOOKUP(a,H$23:I$31,2,FALSE))))

enter image description here

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