Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Unhappy 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Identifying the # of cells containing data WA Excel Worksheet Functions 2 March 17th 09 05:17 PM
Identifying cells that add up to a certain amount Hifi Excel Worksheet Functions 5 June 3rd 08 07:20 PM
Identifying updated cells MLK Excel Worksheet Functions 2 January 10th 07 08:47 PM
Identifying #N/A cells Lee Harris Excel Worksheet Functions 1 November 18th 05 03:57 AM
Identifying Cells with formulas VETcalc Excel Worksheet Functions 2 August 13th 05 06:49 AM


All times are GMT +1. The time now is 12:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"