TextJoin Formula

[Richard2542]

I am attempting to combine 2 adjacent columns of data into 1 text string (see attachment) using the TextJoin formula - I need to separate each combined result with a semi-colon.

 

[Fluff]

What do you mean? It does include the player name.

 

[Richard2542]

Fluff...excellent - sorry to be such a "pain", but 1 last request is to sort by Rank and display results as shown in attachment.

 

[Fluff]

Can you post some sample data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Richard2542]

This works, I'd like to include Player Name -

Fluff, I'm having issues with the XL2BB upload; my best shot is to attach the image - I just need to include the Player Name then Rank the Players by Total wins

 

[Fluff]

In that case can you jus copy paste straight from Excel onto the board.

 

[Richard2542]

Text Join Formula
Question: create and sort TextJoin formula (results shown in A16)
Total Wins	Rank	Player​	Combined​	Formula: D6:D10​
119	1	Richard J​	1 - Richard J​	=IF(B6="","",B6&" - "&C6)
107	4	Dave B​	4 - Dave B​
111	3	Larry S​	3 - Larry S​
115	2	Jim F​	2 - Jim F​
Adjusted Formula:
=TEXTJOIN("; ",,SORT(A6:A9&" - "&B6:B9))​
107 - 4; 111 - 3; 115 - 2; 119 - 1​
Preferred List shown by Rank (based on Total Wins)
(1) Ricard J - 119 (2) Jim F - 115 (3) Larry S - 111 (4) Dave B - 107​

 

[Fluff]

Thanks for that, how about

Fluff.xlsm
	A	B	C
1	Total Wins	Rank	Player
2	119	1	Richard J
3	107	4	Dave B
4	111	3	Larry S
5	115	2	Jim F
6
7
8
9
10
11
12	(1) Richard J - 119 (2) Jim F - 115 (3) Larry S - 111 (4) Dave B - 107
Main

Cell Formulas
Range	Formula
A12	A12	="("&TEXTJOIN({") "," - "," ("},,SORT(CHOOSECOLS(A2:C10,2,3,1)))

 

[Richard2542]

Thanks for that, how about

Fluff.xlsm
	A	B	C
1	Total Wins	Rank	Player
2	119	1	Richard J
3	107	4	Dave B
4	111	3	Larry S
5	115	2	Jim F
6
7
8
9
10
11
12	(1) Richard J - 119 (2) Jim F - 115 (3) Larry S - 111 (4) Dave B - 107
Main

Cell Formulas
Range	Formula
A12	A12	="("&TEXTJOIN({") "," - "," ("},,SORT(CHOOSECOLS(A2:C10,2,3,1)))

Perfect - thanks sooooo much

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Richard2542]

You're welcome & thanks for the feedback.

Fluff...I've been trying add a space between total wins and the next rank...i have tried everything - no luck (I'm trying to show more separation between each player (this is not a big deal, however, graphically it might be easier to read..