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:
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.Natalie (149), Timothy (51), Amy (31), Alison (24)
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.
Bookmarks