Excel Formula to identify similar text
Closed
Reinette
-
Updated on Jul 11, 2019 at 06:21 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 6, 2019 at 11:42 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 6, 2019 at 11:42 AM
Related:
- Excel formula to find similar text in one column
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Percentage formula in excel marksheet - Guide
- Gif in excel - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jul 11, 2019 at 12:14 PM
Jul 11, 2019 at 12:14 PM
Hi Reinette,
What a messy question.
Find the word Recorder in column B and output TRUE or FALSE is what the following formula will do:
=IF(ISERROR(SEARCH("Recorder",B2)),"False","True")
Best regards,
Trowa
What a messy question.
- "Voice Recorder Sony ICD-PX720" is not in column A but B according to your sample data.
- "AMPED FIVE_ Audio Receiver Oryx_TRUE " doesn't contain "Recorder" but is marked TRUE.
- You want to look in column B, but this string "AUDIO VIDEO RECORDER _ Video Camera Sony Digital_ TRUE " shows Recorder in column A and gets the TRUE mark.
Find the word Recorder in column B and output TRUE or FALSE is what the following formula will do:
=IF(ISERROR(SEARCH("Recorder",B2)),"False","True")
Best regards,
Trowa
Gerberreinette
Posts
13
Registration date
Friday March 4, 2016
Status
Member
Last seen
July 31, 2023
2
Jul 18, 2019 at 08:57 AM
Jul 18, 2019 at 08:57 AM
Hi TrowaD
If you have the word "Tree" in column A, I want to find that same word in column B.
If the word is in Column A and B the formula must give me a result.... for example True
If it is only in one column it should give me a result.... for example False.
Or even if part of a word can be found in both columns the formula should say True.
For example in column A is "Tree" and in column B is "Tree House" it should also give me the result True.
Hope this is clear.
Thank you for your help I appreciate it.
If you have the word "Tree" in column A, I want to find that same word in column B.
If the word is in Column A and B the formula must give me a result.... for example True
If it is only in one column it should give me a result.... for example False.
Or even if part of a word can be found in both columns the formula should say True.
For example in column A is "Tree" and in column B is "Tree House" it should also give me the result True.
Hope this is clear.
Thank you for your help I appreciate it.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Aug 6, 2019 at 11:42 AM
Aug 6, 2019 at 11:42 AM
Hi Reinette,
Then I was pretty close already, just use the same formula for column A and then combine the 2:
=IF(AND(ISERROR(SEARCH("Tree",A1))=FALSE,ISERROR(SEARCH("Tree",B1))=FALSE),"True","False")
So if both searches don't produce an error, tree must have been found in both columns, thus the result is true.
Best regards,
Trowa
Then I was pretty close already, just use the same formula for column A and then combine the 2:
=IF(AND(ISERROR(SEARCH("Tree",A1))=FALSE,ISERROR(SEARCH("Tree",B1))=FALSE),"True","False")
So if both searches don't produce an error, tree must have been found in both columns, thus the result is true.
Best regards,
Trowa
Jul 12, 2019 at 03:29 AM
Sorry if the question is messy. If you have a list of words in Column B how do you identify that specific words in Column A.
Thank you for the help.
Regard
Updated on Jul 16, 2019 at 11:25 AM
You didn't address the messiness/confusion. If I can't tell how you got the result, then I can't get Excel to show the correct result either.
Best regards,
Trowa