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
=TRUEand 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.
Returns the last task belonging to “Adam” which is “Cook steaks.”
|Was this article helpful?|