Tough Excel Challenge - Can you help?

grimlynsan · 07-31-2009, 11:14 AM

Hello Excel Gurus!

I’m hoping you can help me! I’ve searched everywhere but have not go even close to solving this problem. I’ll be ever so impressed if you can!

I have two sheets that need to have unique partial matches aligned side by side. My first sheet is my database. The righter most column of this sheet contains a unique combination of letters and numbers.

My second sheet contains a single column which I export each month from our CMS and is a list of URLs. Within each of these URLs appears the unique set of letters and numbers from sheet 1 (and only appears once).

There are about thrice as many URLs in sheet 2 as there are entries in my sheet 1 database.

Ideally, I would like the URL from sheet 2 that contains the unique combination from sheet 1 to be pasted in the cell immediately to the right of the given unique combination.

However, I will settle for a list of trues and falses next to the URLs in sheet two that I can erase the falses, sort and paste next to the sorted list from sheet 1.

Any takers?

Thank you,

Lee

**mudraker** · 07-31-2009, 11:40 AM

Here's a Tough Excel Challenge for you

Please take a couple of minutes and read ALL the Forum Rules then edit your thread title by following the instructions in the rules (Rule 1) so that it better discribes your problem/request

**rasonline** · 07-31-2009, 03:06 PM

Originally Posted by mudraker

Here's a Tough Excel Challenge for you

Please take a couple of minutes and read ALL the Forum Rules then edit your thread title by following the instructions in the rules (Rule 1) so that it better discribes your problem/request

LOL.. :D

Mudraker, it sounds like your problem isn't a difficult one. Why don't you post up a sample file.

grimlynsan · 08-03-2009, 04:59 AM

Firstly, as a complete Excel Noob, I don't necessarily know what category this comes under as I haven't the first clue as to how to solve it. That's why I joined your forum - for help - not sarcastic comments.

Secondly, just because you're not capable of solving the problem, it doesn't mean you have have to belittle me.

Thanks for making me feel so welcome, i'll be sure to recommend your site, complete with its friendly user community, to all my friends.

Kind Regards,

Lee

**martindwilson** · 08-03-2009, 05:27 AM

wow! there go the toys right out of the pram!
you were asked to change the title,hardly difficult that eh?
then to start further demonstrate your petulance you resort to childish name calling.
must be "web rage" eh? hiding behind a username ,like the little man shouting and screaming in his car at the six foot thug feeling safe in the knowledge that he's locked in a tin box.
Please by all means tell your friends. If they have the same attitude as you this community certainly wont welcome or help them any way.

**daddylonglegs** · 08-03-2009, 05:48 AM

Hello Lee,

There are many contributors here who give their time and expertise free, they don't expect to be given abuse in return. I've edited your post to remove the most offensive comment.

You are banned and thread is closed....