listing names

[Gamnis]

Hi all

I need help with a formula.


I have a bunch of names in a column like this

A

--

1 John

2 Benny

3 John

4 Anna

5 Anna

6 Benny

7 Beatrice

and so on...


Many of the names occur multiple times, but I whant to return them only once.

like this

B

--

1 Users: John, Benny, Anna, Beatrice, and so on...


Anyone know a way to do this?

 

[Goombah29]

If I'm following you correctly, all you should have to do is delete duplicate values. Of course if you need your list in-tact delete on a different tab or area and then bring where you need it at. On the ribbon go to the DATA tab, highlight the list of names, then Remove Duplicate Values. It will ask you a quick question, and then it will display each name only once.

Now if you have 4-Anna and 5-Anna (like the actual number on the same cell) then you'll have to remove that 1st.

Make sense? Or am I thinking of this wrong?

~Andrea

 

[oldchippy]

Hi Gamnis,


Chandoo has a video here showing how to remove duplicates


http://chandoo.org/wp/2009/06/22/remove-duplicates/

 

[Gamnis]

No this is not exactly how I whant it.

I have the list of names wich is from a spredsheet with alot of different data based on time.

Ex:

date;data;data;data;...;username1

date;data;data;data;...;username2

date;data;data;data;...;username3

and so on...


I whant to list the usernames in the same cell

One way to do it is like this

=AC7 &" "& AC8 &" "& AC9 &" "& AC10 & "..."


result:

username1 username2 username 3 ...


Do to the form of the spreedsheet this function is not possible.

so if I can use an area like ="function"(AC7:AC10) would help alot

 

[Hui]

Have a read of Jive's post towards the bottom of

http://chandoo.org/wp/2008/05/28/how-to-add-a-range-of-cells-in-excel-concat/

That will do what you want