| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare two columns with different codes
Dear all
I have two columns with codes. The first column include the main coding (ie: ab1, ab101, ab10101,...) The second column include the same codes, but the first leter is always C. So the coding is (ie: cab1, cab101, cab10101,...) I have notice that some of the codes in the second column are missing. There is any way that i can make a check regarding the second column based the first one. I tried to use the vlookup but the problem is that the first letter is c and basically the two codes looks different. Can anyone direct me of how i can make the comparison between the two columns? Thanks in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare two columns with different codes
--Insert a column in between. Say Col B.
--In cell B1 apply the formula; and copy down as required..Will return the text incase the correspondin code in ColA is missing in ColC =IF(COUNTIF(C:C,"c" & A1),"","Missing in Column C") -- Jacob (MVP - Excel) "Manos" wrote: Dear all I have two columns with codes. The first column include the main coding (ie: ab1, ab101, ab10101,...) The second column include the same codes, but the first leter is always C. So the coding is (ie: cab1, cab101, cab10101,...) I have notice that some of the codes in the second column are missing. There is any way that i can make a check regarding the second column based the first one. I tried to use the vlookup but the problem is that the first letter is c and basically the two codes looks different. Can anyone direct me of how i can make the comparison between the two columns? Thanks in advance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare two columns with different codes
Thank you very much for your suggestions
"Jacob Skaria" wrote: --Insert a column in between. Say Col B. --In cell B1 apply the formula; and copy down as required..Will return the text incase the correspondin code in ColA is missing in ColC =IF(COUNTIF(C:C,"c" & A1),"","Missing in Column C") -- Jacob (MVP - Excel) "Manos" wrote: Dear all I have two columns with codes. The first column include the main coding (ie: ab1, ab101, ab10101,...) The second column include the same codes, but the first leter is always C. So the coding is (ie: cab1, cab101, cab10101,...) I have notice that some of the codes in the second column are missing. There is any way that i can make a check regarding the second column based the first one. I tried to use the vlookup but the problem is that the first letter is c and basically the two codes looks different. Can anyone direct me of how i can make the comparison between the two columns? Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding matching codes in two different columns | Excel Discussion (Misc queries) | |||
| Attempting to compare and deduct values based on date codes | Excel Discussion (Misc queries) | |||
| lining up 2 columns of zip codes | Excel Discussion (Misc queries) | |||
| Compare two columns | Excel Discussion (Misc queries) | |||
| I have two columns (A) and (G) that have like product codes however | Excel Worksheet Functions | |||
Hybrid Mode
