Forum Discussion
Solved
Excel Help with filtering data
I need assistance with a spreadsheet where I want to compare 2 columns. Column A contains cells where each cell contains only 1 physician's name. Column B contains cells where there are multiple phys...
You have used "" where I had ".
If you use comma as decimal separator, the formula should be
=ISERROR(MATCH("*"&$A2&"*";$B:$B;0))
HansVogelaar - I am receiving a error message that says "There's is a problem with this formula. Not tring to type a formula? When the first character is an equal= or minus -sign, Excel thinks it is a formula." This is what I typed in:
=ISERROR(MATCH(""*""&$A2&""*"",$B:$B,0))
You have used "" where I had ".
If you use comma as decimal separator, the formula should be
=ISERROR(MATCH("*"&$A2&"*";$B:$B;0))