# Name (Value) in comma seperated list

1. ## Name (Value) in comma seperated list

A2:A98 is list of names
B2:B98 is a list of values

I have Excel 2003.

In the sample file the table has been shortened to 25 rows

Example Output:

Natalie (149), Timothy (51), Amy (31), Alison (24)
I need a comma separated list consisting of "name (value), name (value), name (value)", Where the value is greater than 20 preferably sorted from highest to lowest by the value.

I did some basic searching and didn't find anything like what I am looking for if it's out there I apologize in advance!

I can get the list of the names but have not been able to figure out how to add the value in parenthesis.

2. ## Re: Name (Value) in comma seperated list

1 -What version of Excel you use?
2 - sorted from highest to lowest by name or value
3 - the example is preferable also.

3. ## Re: Name (Value) in comma seperated list

Sorry this is my first time and post here. I have updated the original post with the information requested.

4. ## Re: Name (Value) in comma seperated list

Please update your version and general location in your profile. This will assist those willing to help you with the proper solution geared to your version of excel and your general location. While you may think this is not important, please understand that conventions within excel differ by location and versions.

It is Done.

6. ## Re: Name (Value) in comma seperated list

You can sort the data in columns A and B into the order that you require.

Then you could use this formula in D2:

=D1&IF(OR(A2="",B2=""),"",A2&" ("&B2&"),")

Copy this down to the bottom of your data.

Then to get the final csv list (without the trailing comma), you can use this in F1:

=SUBSTITUTE(INDEX(D:D,COUNTA(D:D)+1)&"zz",",zz","")

Hope this helps.

Pete

7. ## Re: Name (Value) in comma seperated list

I came up with the full solution using parts from your reply.

I ended up using an array function of

``Please Login or Register  to view this content.``
E is cases
B is county names

or using the example

``Please Login or Register  to view this content.``
A is names
B is values

If anyone wants to use the example paste the formula then press ctrl-shift-enter.

Is it possible to make a one time donation to the forum. It won't be much because I am tight on money right now.

8. ## Re: Name (Value) in comma seperated list

How can you use the TEXTJOIN function if you are using Excel 2003? It wasn't available for that version.

Anyway, glad you found a solution. If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

9. ## Re: Name (Value) in comma seperated list

My version at home must be different than the office. Either way it works! will just get them to update the office. Reputation sent!

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1