Searching a cell with data separated with a comma to return a different value

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

I don't quite understand but here's my attempt (column B):

Please Login or Register  to view this content.

Originally Posted by orshims

hi all

does this mean that this cant be done??

Please let me know!!

thanks

Try this formula in B1 of your uploaded workbook and fill down:

Formula:

Please Login or Register  to view this content.

Try this formula in C1:

Formula:

Please Login or Register  to view this content.

It produces this:

Row\Col	A	B	C	D	E	F
1	89,90,91,98,121,126	turning	other		103	93
2	89,90,91,109,109,121,126	turning	other		104	94
3	89,90,91,109,109,121,126	turning	other		105	95
4	89,90,91,109,109,121,126	turning	other		106	123
5	89,90,91,109,109,121,126	turning	other		107	125
6	89,90,91,109,109,121,126	turning	other		108	97
7	89,90,91,103,103,103,121,126	other	milling		124	98
8	89,90,91,103,103,103,121,126	other	milling		110	99
9	89,90,91,107,107,107,121,126	other	milling			100
10	89,90,91,107,107,107,121,126	other	milling			101
11	89,90,91,103,103,121,126	other	milling			102
12	89,90,91,109,121,126	turning	other			109
13	89,90,91,93,121,126	turning	other
14	89,90,91,103,98,114,119,121,126	turning	milling
15	89,90,91,109,103,119,121,126	turning	milling

The file is attached.