Hi,
I have two lists in Column B & Column C.On matching D2 & D3 it is prompting FALSE.
How can I match this so that TRUE can be displayed instead of FALSE incorporating differences in formula.
Thanx in anticipation as usual.
Hi,
I have two lists in Column B & Column C.On matching D2 & D3 it is prompting FALSE.
How can I match this so that TRUE can be displayed instead of FALSE incorporating differences in formula.
Thanx in anticipation as usual.
You have to add, what the problem causes.
One of the problems is ;
Select range C1:C3
CTRL + H => find ; => replace by (leave blanc) => replace all.
Edit
The second problem is the leading spaces in your text.
Use the formula trim on of all data of the sheet.
After that the problems are solved in this question.
Last edited by oeldere; 05-03-2020 at 08:45 AM. Reason: solved also the second problem
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Without using find and replace ,how it can be solved as I have problem in using find and replace.
D2 =replace(B2,search(";",B2,1),1,"")
for the second row (b3) I have no solution at this moment.
It will something be with REPT
Last edited by oeldere; 05-03-2020 at 09:18 AM. Reason: It will something be with REPT
Maybe it is a better idea to use data validations for column D to prefent unaccepted input.
Please try at D2
=TRIM(B2)=TRIM(SUBSTITUTE(C2,";",))
@ paradise2sr
Please also reply on my solution in #5.
I have not tested post#4&5 as I was expecting a single formula which post #6 was successfully worked.
Thanx all of for your kind efforts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks