Single value in multiple value

[vibhor sanjar]

Hiiii....

This is the third time I am posting my problem. Please help in by solving my proble. I want to convert single value in a cell in multiple value in the same cell. I also want to define a delimiter in the same cell.

Also don't want to use split function as it creates different cells.

For Example: "34,654, 5667, 566" is a value in the same cell. Excel takes it as a single value, how do I make excel to take it as multiple value in the same cell.


Plzzzzz.... help me for the same....

 

[vibhor sanjar]

For Eg........


Section

245a, 28, 587, 687
245a, 574, 875, 985
653, 574, 245, 689, 245


Here are three cells. " Section is the column heading. All have multiple values. Now if I want to filter the cell having value " 245" or "245 and 574".

 

[erik.van.geit]

That doens't make sense.
245
OR
245 and 574

the second condition will have no additional items

I changed it
245 OR (555 AND 574)

  A                        B     
1 section                        
2 245a, 28, 587, 687       TRUE  
3 245a, 574, 875, 985      TRUE  
4 653, 574, 245, 689, 245  TRUE  
5 555a, 28, 574, 687       TRUE  
6 444, 574, 875, 985       FALSE 
7 653, 574, 689            FALSE 
8 653, 574, 555            TRUE  

Sheet1
[Table-It] version 07 by Erik Van Geit

RANGE FORMULA (1st cell)
B2:B8 =OR(ISNUMBER(FIND(245,A2)),AND(ISNUMBER(FIND(555,A2)),ISNUMBER(FIND(574,A2))))

[Table-It] version 07 by Erik Van Geit

best regards,
Erik

 

[vibhor sanjar]

k lets go by ur value then.

How wil you filter in these two case:

245a only

245a and 574 both


Again all the multiple values are in same cell and excel wil take these multiple value as single value.

 

[erik.van.geit]

I've given you an example using a helper column with formula.

The example you have in your last post, which is about the same as the previous, doesn't make sense, for the same reasons as I explained before.
Just play with the formula in helpercolumn and you can get as many combinations of criteria as you like.