Prev: Need Help!!
Next: Can a Excell File be converted to Access
From: kokhong on 7 Mar 2010 21:17
is there any way to sort my data in excel from

IP address Username
10.10.10.1 A
10.10.10.1 B
10.10.10.1 C
10.10.9.2 D
10.10.9.3 E
10.10.9.3 F

TO

IP address Username
10.10.10.1 A,B,C
10.10.9.2 D
10.10.9.3 E,F

From: מיכאל (מיקי) אבידן on 8 Mar 2010 03:08
Although it can easily be accomplished with VBA Macro - I would suggest
another approach:
1) In the picture - the long formula is an array formula, and is to be
confirmed with CTRL+SHIFT+ENTER rather than with simply ENTER.
The curly brackets {} are not to be typed manually, those are entered by the
“Excel”, when the formula is entered as an Array formula.
2) Column "C" and on maybe hidden but not deleted !
http://download.cnet.com/Morefunc/3000-2077_4-10423159.html
3) In order to use the MCONCAT function you will have to install the
MOREFUNC add-in:
http://img13.imageshack.us/img13/6234/nonamek.png
Micky


"kokhong" wrote:

> is there any way to sort my data in excel from
>
> IP address Username
> 10.10.10.1 A
> 10.10.10.1 B
> 10.10.10.1 C
> 10.10.9.2 D
> 10.10.9.3 E
> 10.10.9.3 F
>
> TO
>
> IP address Username
> 10.10.10.1 A,B,C
> 10.10.9.2 D
> 10.10.9.3 E,F
>
 | 
Pages: 1
Prev: Need Help!!
Next: Can a Excell File be converted to Access