equation to place commas in list properly
I have a list that appears in a report that shows which of the items 1-42 have a specific entry. The only way I can find to write the calculation is to either put a comma after or before every number except the first or the last number. The problem is if the first or last number aren't included in the list I get a comma hanging out there for no reason and it makes the report look sloppy. Here is a sample of what I currently use where if #1 isn't in the list the entire list is preceded by a comma.