Match cells in excel with all characters same except one
Solved/Closed
Murtuza
Posts
6
Registration date
Wednesday September 4, 2013
Status
Member
Last seen
September 7, 2013
-
Sep 4, 2013 at 01:19 PM
Blocked Profile - Sep 27, 2015 at 06:39 PM
Blocked Profile - Sep 27, 2015 at 06:39 PM
Related:
- Excel match first 8 characters
- Tekken 8 download pc - Download - Fighting
- Samsung mobile reset code 8 digit - Guide
- Windows 8 download - Guide
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
2 responses
Well, for that function you get the LEFT.
as in...
=IF(LEFT(F2,5)=LEFT(G2,5),IF(F2=G2,TRUE, FALSE),FALSE)
I REALLY HOPE THIS ISNT A SCHOOL PROJECT.
So lets take a look at what happened:
First Formula:
=If(logic test, true, false)
So we then nested in the LEFT Method, that says look at the cell, and return the LEFT MOST 5 characters in the logical test of the IF. So if the left most matches, it returns a true.
Second Formula:
So in the True column of the first IF statement, we have to run what happens when it is true.
=if(f2=g2,true,false)
SO we then look at the whole value of the cell, and match it completely, nested within another if statement.
Please understand, you can use RIGHT to check the right most for trailing characters, also.
Have Fun!
//ark
-Contributor
as in...
=IF(LEFT(F2,5)=LEFT(G2,5),IF(F2=G2,TRUE, FALSE),FALSE)
I REALLY HOPE THIS ISNT A SCHOOL PROJECT.
So lets take a look at what happened:
First Formula:
=If(logic test, true, false)
So we then nested in the LEFT Method, that says look at the cell, and return the LEFT MOST 5 characters in the logical test of the IF. So if the left most matches, it returns a true.
Second Formula:
So in the True column of the first IF statement, we have to run what happens when it is true.
=if(f2=g2,true,false)
SO we then look at the whole value of the cell, and match it completely, nested within another if statement.
Please understand, you can use RIGHT to check the right most for trailing characters, also.
Have Fun!
//ark
-Contributor
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 27, 2015 at 10:47 AM
Sep 27, 2015 at 10:47 AM
Davcorp10, Good morning.
Try to use:
=IF(OR(F2="",G2=""),"",IF(F2=G2,TRUE,FALSE))
Is it what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
=IF(OR(F2="",G2=""),"",IF(F2=G2,TRUE,FALSE))
Is it what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Sep 5, 2013 at 01:28 AM
Hope this helps
Sep 5, 2013 at 08:24 AM
So...you really need a macro, not a formula, right?
Sep 5, 2013 at 01:55 PM
Sep 5, 2013 at 02:03 PM
A macro can be written as dynamic and not have static "calls", so if you are looking to change the "selection" of cells down a row, then you will need a macro. I willlook into it after a see an example of data. Thanks.
Sep 7, 2013 at 09:02 AM
A B
12345abcd 56789reft
45678defghijk 78902tery
67890sdf 12345abc
So in the above case the third value in column B partially matches the first value in col A . The first 5 digts in both the cells (A1 and B3) are same which is the first condition to be satisfied. Only if that is true should the remaining values be checked and if all the remaining characters are same or all characters except any one are same it should give me true. The problem is compounded by the fact that the length of the strings in col A are not equal. However the no of numeric characters in the string are always 5 irrespective of the total length of the string. Hope I have been able to explain my self more clearly this time. If you can provide me a formula or a macro it will be simply awesome.Also if you could guide me on how to deploy macros in excel.