Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Identifying common data between 2 cells
Hello-
I am trying to identify common criteria between 2 cells using Excel 2007. For instance: I have a series of numbers and possibly letters in 1 cell (part number). I want to compare to another cell that has similar but not exactly the same data. The info might look like this.... (Cell 1) 55758 vs. (Cell 2) AVT55758 or possibly (Cell 1) AB55758 vs. (Cell 2) XY55758000. The difference in how the data is presented is how a vendor might list a product. In reality, it's the same product. I want to be able to either have a macro or a formula that could match a minimum of 4 consecutive numbers and give me a result that says it's a good match. If it's 5 consecutive numbers, then it should say it's an excellent match. It's a time eating process to manually view data and a macro or formula like this would be a great time saver. Anyone have any ideas? Thanks - Mark |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Identifying common data between 2 cells
Hi Mark,
Am Fri, 16 Nov 2012 19:13:39 +0000 schrieb MRPRMR: For instance: I have a series of numbers and possibly letters in 1 cell (part number). I want to compare to another cell that has similar but not exactly the same data. The info might look like this.... (Cell 1) 55758 vs. (Cell 2) AVT55758 or possibly (Cell 1) AB55758 vs. (Cell 2) XY55758000. The difference in how the data is presented is how a vendor might list a product. In reality, it's the same product. you are comparing A1 and B1: =IF(ISNUMBER(FIND(RIGHT(A1,5),B1)),"Excellent Match",IF(ISNUMBER(FIND(RIGHT(A1,4),B1)),"Good Match","")) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying the # of cells containing data | Excel Worksheet Functions | |||
Identifying cells that add up to a certain amount | Excel Worksheet Functions | |||
Identifying updated cells | Excel Worksheet Functions | |||
Identifying #N/A cells | Excel Worksheet Functions | |||
Identifying Cells with formulas | Excel Worksheet Functions |