FindLastRow( )

[LoriA]

FINDLASTROW()

Description

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.

---

Syntax

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

Required

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

Optional

• 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.

---

Example

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

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

Was this article helpful?

• Yes
• No