Finding specifik letter combinations.

**FabianOlsson** · 06-10-2013, 05:42 AM

I want to solve this:

I am importing an exellist with articlenumbers prices and so on.
The problem is that I need the articles to be placed in diffrent article groups.
I'll give you an example:

article names ( column A ):
exhaustpipe CRF250
Plastic kits YZF450
Wheel RMZ250

Articlegroups ( column B ):
( Empty )

I want the article groups to fill them self out according to the "CR" "YZ" and so on.
So if there is CRF in the name of the article it should have " Honda " as groupplacement.
If it has YZ I want it to have " Yamaha " as groupplacements and so on.
( there is a total of 12 diffrent letter combinations )

I hope you guys understand what I'm searching for.
And please explain to me how the formula I search for works and so on caus I'm quite new to excel

EMX prislista1.xlsx

Thanks alot

**zbor** · 06-10-2013, 05:45 AM

can you upload example workbook?

**FabianOlsson** · 06-10-2013, 06:29 AM

I uploaded it above recently

**zbor** · 06-10-2013, 07:07 AM

Here, Try this:

**FabianOlsson** · 06-10-2013, 08:14 AM

I want to search C1 and down instead of N1 and down, I tried to exchange the N1's to C1's in the formula but it did'nt work as I wanted

**zbor** · 06-10-2013, 09:19 AM

After changing reference in the formula comfirm it with ctrl+shift+enter (not just enter. A curely brackets {} must appear around your formula, and those brackets can not be entered manually).

Also, change N1 to C1 in all places.

Does this work for you?

**FabianOlsson** · 06-10-2013, 09:27 AM

It worked, can't tell you how glad I am this is solved.
Loads of creds to you for the help

**FabianOlsson** · 06-12-2013, 03:52 AM

I recently found a problem in the document.
It shows the value HUSABERG even thou there is no HUS found in the cell in column C in some cases.
for example cell C 1401 does not show the value HUS but it is still showing Husaberg as if the letters HUS was found in the cell.

emx prisartikellista fixad.xlsx

**zbor** · 06-12-2013, 05:30 AM

Try this:

But also not that according to your example Husaberg return values also for FE not only HUS

Formula:

Please Login or Register  to view this content.

comfirmed with ctrl+shift+enter

**FabianOlsson** · 06-12-2013, 10:06 AM

When I enter the formula with ctrl+Shift+Enter I get a message that says there is something wrong in the formula you gave me.

Finding specifik letter combinations.

LinkBack

Thread Tools

Rate This Thread

Display

Finding specifik letter combinations.

Re: Finding specifik letter combinations.

Re: Finding specifik letter combinations.

Re: Finding specifik letter combinations.

Re: Finding specifik letter combinations.

Re: Finding specifik letter combinations.

Re: Finding specifik letter combinations.

Re: Finding specifik letter combinations.

Re: Finding specifik letter combinations.

Re: Finding specifik letter combinations.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions