FindLastRow( )



FINDLASTROW() is a function that returns a rowlink based on a condition. The search is conducted sequentially, starting at the bottom, and returns the last matching row. If no matching row is found, #N/A is returned.


=FINDLASTROW(table, "condition", [condition_parameters])


  • Table/filter: A table or filter that returns a list of rows.


  • Condition: This condition is applied to each row in sequence, starting from the bottom, until it is evaluate =TRUE and the matching row is returned.

  • Condition parameters : Conditions can be parameterized like A1 = %. In this case “%” will be replaced by the values provided in the condition parameters before the condition is evaluated.


=FINDLASTROW(Tasks,"Tasks[Owner]=%", "Adam")

Returns the last task belonging to “Adam” which is “Cook steaks.”

Was this article helpful?
  • Yes
  • No

0 voters