I currently have a spreadsheet to keep track of scores in a card game. There can be between two and five players. I have the following:
| Players |
|----------|
| Dave |
| Paul |
| John |
| |
| |
At the moment I use:
= JOIN( " vs " ; C10:C14 )
But the problem is I then end up with Dave vs Paul vs John vs vs
.
Is there a way to make it say Dave vs Paul vs John
but if I had more players, Dave vs Paul vs John vs Rob
with one formula?
Best Answer
Yes, by
FILTER
ing the array:Thus, the
JOIN
method will only operate on non-empty cells.I have set up an example spreadsheet.
Also, check the Google Spreadsheets function list (search for
FILTER
).