Hello again it's been a while,
I am running into a bit of an issue where I have to compare one column with "Clean Data" with another that has data with added baggage. The purpose of this is to figure out if the servers we have that should be backed up have been backed up by our agent.
Here is a test file I have been playing with: http://www.filedropper.com/testlist
So far none of the things I have tried have granted the expected results my last attempt was =IF(OR(COUNTIF([@[Server List]], "*"&BackupList[Backup List]&"*")), "Yes", "No") but that only returns the expected result if the "Dirty List" is an exact cell match which is sadly rarely the case. Is there a way to have it look for the cell value and have it ignore the irrelevant stuff?
I am running into a bit of an issue where I have to compare one column with "Clean Data" with another that has data with added baggage. The purpose of this is to figure out if the servers we have that should be backed up have been backed up by our agent.
Here is a test file I have been playing with: http://www.filedropper.com/testlist
So far none of the things I have tried have granted the expected results my last attempt was =IF(OR(COUNTIF([@[Server List]], "*"&BackupList[Backup List]&"*")), "Yes", "No") but that only returns the expected result if the "Dirty List" is an exact cell match which is sadly rarely the case. Is there a way to have it look for the cell value and have it ignore the irrelevant stuff?