sorting values

[ori]

i have 2 column:

1 2

1 5

1 6

2 8

2 3

3 4

4 9

the results i need:

1 2,5,6

2 8,3

3 4

4 9

 

[Faseeh]

Hi Ori,


Do you want result 2,5,6 in single cell or in separate cells??


Regards,

 

[NARAYANK991]

Hi Ori ,


Another doubt : are the values in the second column numbers or text or a mixture of both ? If they are numbers , will they be single-digit numbers , or can they be of any value ?


Narayan

 

[ori]

hi,


i need the result in single cell seperated by ","

the values are numbers, can be up to 5 digits


thanks

 

[NARAYANK991]

Hi ,


Concatenating and getting the several values in one cell is not possible through formulae , in my opinion. Is VBA acceptable to you ?


Using formulae , you can put the multiple values in several columns , and then use a separate column to concatenate the values in these columns. Check out this file here :


http://speedy.sh/N84y3/Ori-Book2.xlsx


Narayan