I am trying to create a report feature where once the user runs the report, they can select lines by entering an "x". Using those selected lines, I want to concatenate the selected values with a comma separator. The only solutions I've seen use arrays or Visual Basic, neither of which are an option.
Date
Votes
2 comments
-
Harry Lewis Hello Jason -
Here's how I would do it:
I have my NL(Rows) function in column C and the value I want to concatenate in column D.
In column E, I keep a running comma-delimited list (cell E2 has a blank to provide the starting point for my IF functions).
Then I use the OFFSET function to reference the last of the running lists in column E.
Here is what the result looks like:
-
Jason Ford Thanks for this solution, Harry, this method worked perfectly.
Please sign in to leave a comment.