I want to have formula which results in the latest date of an item based on matching multiple criteria from 2 columns and search another column for partial text. I can get the latest date matching 2 criteria but can't figure out how to add a search function to search a column for a partial text.
See I2 for my attempt at adding this search function and an array. I get the message of entering to many arguments.
Thank you for any support.
Bookmarks