79274628

Date: 2024-12-12 10:07:00
Score: 1.5
Natty:
Report link

Here's one way (probably overkill), and you require Excel 365:

=LET(_Data,$B$4:$E$19,
_UniNZ,UNIQUE(FILTER(_Data,TAKE(_Data,,1)<>"","")),
_Rank,XMATCH(TAKE(_UniNZ,,1),TAKE(_UniNZ,,1)),
_Apply,XLOOKUP(Take(_Data,,1),TAKE(_UniNZ,,1),_Rank,""),
_Apply)

Formula applied in cell A5 of your sheet: Result

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