Previous Topic Next Topic

Finding words in Excel Cells

Closed
Sparky - Dec 14, 2011 at 09:55 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 15, 2011 at 06:07 PM
Hello,

Hello,
I'd like to scan a column for any word that's in a list in another sheet and put a code (e.g. "A") on the cell next to it each time it finds it. In this case, the word might be by itself or in the middle of a sentence.



Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 14, 2011 at 10:18 AM
This thread should give you a very good start

https://ccm.net/forum/affich-606042-excel-vba2010-select-cells-between-2-keywords?full
Sparky
Dec 15, 2011 at 05:52 AM
This is almost It, Unfortunately only works when both columns contain lists of one word per cell.

=IF(COUNTIF($M:$M,D2)>=1,"Destroy","")

D equals my column of Titles containing many words M is my list of keywords.

I need to look in a column of key words (One per Cell) and if any of the keywords appear in a cell containing many words The letter D will appear in an adjacent cell.

Many Thanks
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 15, 2011 at 06:07 PM
Have you read this part of thread

https://ccm.net/forum/affich-606042-excel-vba2010-select-cells-between-2-keywords?full#10

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response