I need to copy a portion of text from one cell based on a cross-reference to another cell

**reclaimio** · 11-19-2015, 06:07 PM

I have a sheet with 5000 skus. There can be a number of skus tied to the same model. Using another formula we made a column called "Also Comes In" to show the other skus in that same model. The problem we have is some of them include the initial sku for the row itself. We want all of the other skus in the model excluding the sku for that particular row.

I have attached "sample sheet.xlsx". In this sheet you'll see column A is the particular sku in question, column B is "Also Comes In" and column C is how it should be. I need to create a new column (E) that can copy column B's contents but removing the Column A sku.

Thank you very much for the help!

**Richard Buttrey** · 11-19-2015, 07:09 PM

Hi,

Further analysis might reduce this formula but for the moment

Formula:

Please Login or Register  to view this content.

**LeoTaxi** · 11-19-2015, 08:09 PM

See if it works on a Mac

Kind regards
Leo

Edit: it is a UDF you call with ACI (short for also comes in) and range

for exemple

Please Login or Register  to view this content.

**FDibbins** · 11-19-2015, 08:16 PM

LeoTaxi Sorry for off-topic interjection:

Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

Also, it looks like you have provided a VBA suggestion, but the OP may not know what that is or how to use it. Unless you have included those instruction in the file, you should alos include them in the post

Thanks again for all your hard work here!

**FDibbins** · 11-19-2015, 08:57 PM

Another version...
=IF(RIGHT(C2,LEN(A2))=A2,SUBSTITUTE(C2,", "&A2,"",1),SUBSTITUTE(C2,A2&", ","",1))

**FlameRetired** · 11-19-2015, 09:14 PM

Similar to Ford's another way.

Formula:

Please Login or Register  to view this content.

**FlameRetired** · 11-19-2015, 09:36 PM

Another way.

Formula:

Please Login or Register  to view this content.

I need to copy a portion of text from one cell based on a cross-reference to another cell

LinkBack

Thread Tools

Rate This Thread

Display

I need to copy a portion of text from one cell based on a cross-reference to another cell

Re: I need to copy a portion of text from one cell based on a cross-reference to another c

Re: I need to copy a portion of text from one cell based on a cross-reference to another c

Re: I need to copy a portion of text from one cell based on a cross-reference to another c

Re: I need to copy a portion of text from one cell based on a cross-reference to another c

Re: I need to copy a portion of text from one cell based on a cross-reference to another c

Re: I need to copy a portion of text from one cell based on a cross-reference to another c

Thread Information

Users Browsing this Thread

Similar Threads

Get a cross reference item number based on heading text

Assign a value to a cell based on a portion of the content of another cell

Data Cross Reference (validation) based on Text in a Cell

Formula to Replace Portion of Cell that Contains Matched Text to Cell

[SOLVED] Macro to Copy the Portion of text in Cell

Searching for a portion of text within a cell, then pulling a value from another cell

cross reference to another cell

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions