79099928

Date: 2024-10-17 21:56:42
Score: 1
Natty:
Report link

Use Filter or Query

You may use either:

Filter:

=LET(a,MAX(C2:C4),FILTER(A2:C4,C2:C4=a))

or Query:

=LET(a,MAX(C2:C4),QUERY(A1:C4,"SELECT * WHERE C = "&a,0))

Output:

Filter:

Filter Output

Query:

Query Output

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