|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Matching Data in Columns
Bookmark
"ebraun01" wrote in
message ...
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
|