Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching Data in Columns
I am trying to compare data in one column with another. Let me explain. One column are manufacturer coupons put out in each sunday's paper. The second column is a list of coupons from a specifc store. I would like to create a forumla or something that will reflect when there is a match in each column. It can not be an exact match since the verbiage is not exactly the same. I will provide a short example. 4 Way Nasal Spray $1 (4-8-06)..............All Sunbeam heating pads: 20% off 8th Continent Soymilk .50 (3-5-06).........Aveeno Lip protectant: $2.99 (SS) Betty Crocker Potatoes .35 (3-5-06).......Chex Mix 4.5oz .99 Boston Lens Ca $7.99.......................Clorox (60 oz): .99 Chex Mix 4.5 oz. + .50/2 (3-5-06)...........Comtrex: $5.99 Now in this example, we have a match with the Chex mix. One is a Manufacturer coupon for .50 off when you buy two, in the other column is another Chex Mix coupon for .99 cents. These are close together but in reality both columns can have hundreds of entries and even when sorted alphabetically, not be anywhere near each other. I need something that will will identify all the matches in both columns when the columns don't exactly match, possibly by the first couple words or something. Any suggestions? Or is this possible? -- ebraun01 ------------------------------------------------------------------------ ebraun01's Profile: http://www.excelforum.com/member.php...o&userid=30340 View this thread: http://www.excelforum.com/showthread...hreadid=500035 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching and aranging data form two sources | Excel Worksheet Functions | |||
Data in narrow columns truncated when saving as DBF | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
How to take matching data from 2 columns and put in the same row? | New Users to Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |