Find a word in macro

Closed
Ezhil - May 13, 2010 at 02:18 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 13, 2010 at 07:39 AM
Dear All,

I have a excel sheet, it contains 100 rows value, now I need to find which are the rows has the word "apple", if it has it should return true or false...

anyone can help me on this. please.........
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 13, 2010 at 07:39 AM
To me at least, your question seem rather ambigious

How ever one way is

=IF(ISERROR(FIND("apple", A1,1)),"No Apple","Yes Apple")

IF this is not what you seek, then could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ etc and post back here the link to allow better understanding of how it is now and how you foresee.
0