I've data in 47000 rows and 20 columns. I've hidden all columns except two from which I need to do analysis.
I need to search in these two columns and identify if a particular string exists in either of the columns and return 'yes' or 'no'.
From the below example, I want to search for "Apple" in Col 1 and Col 2 and in Col 3, I should have row 2 and row 4 are marked as yes (for that matter some remark which says yes). Because 'Apple" can be found in row 2 and row 4.
Any formula or function I can use?
<tbody>
</tbody>
I need to search in these two columns and identify if a particular string exists in either of the columns and return 'yes' or 'no'.
From the below example, I want to search for "Apple" in Col 1 and Col 2 and in Col 3, I should have row 2 and row 4 are marked as yes (for that matter some remark which says yes). Because 'Apple" can be found in row 2 and row 4.
Any formula or function I can use?
Col 1 | Col2 | ||||
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>