The FILTER function extracts every matching record while XLOOKUP only returns the first result.
Learn about the filters you’ll use most often and how they work.
The ratable accrual method is a formula for determining income on investments as it's accrued rather than paid and is often used for income tax purposes.