I am building a "matching" app where an incoming csv file is being search for matches to our master customer database and one of those matches are on last name and dob. Here is the formula I am using: If(!IsBlank(ThisItem.Birthdate),If(CountIf(ISK_Clients, cr4d3_birthdate = ThisItem.Birthdate And cr4d3_lastname = Last(Split(Trim(ThisItem.Name)," ")).Result)>0,LightGreen,White)). As we are in testing, one of our testers noted a logic error where the name BRIAN M DAVIS JR did not hit as there is a suffix in the name. How would I adjust this formula to accommodate for this? My thought is to count spaces and if there are three then take the third element? Or would there be a better way?
Thanks for the info
