Hello there,
I have a column that indicates weeks where a class is taking place. However, instead of listing each individual week number, it groups them together. For instance, 20-28 is weeks 20,21,22,23,24,25,26,27,28.
The column has instances of multiple groupings, separated by comma. I include a screenshot below. I'm looking to convert the groupings into individual weeks.
Column N is my own manual working, where I've manually converted the weeks into the output I am looking for. Would there be a combination of formulas, beyond my knowledge, that could take the manual work out of this process?
Note - Some rows are just individual week numbers and do not contain either a comma or dash.
20-28, 33-35
20-24, 26-28, 33-34
Thanks in advance!
Tobermory
I have a column that indicates weeks where a class is taking place. However, instead of listing each individual week number, it groups them together. For instance, 20-28 is weeks 20,21,22,23,24,25,26,27,28.
The column has instances of multiple groupings, separated by comma. I include a screenshot below. I'm looking to convert the groupings into individual weeks.
Column N is my own manual working, where I've manually converted the weeks into the output I am looking for. Would there be a combination of formulas, beyond my knowledge, that could take the manual work out of this process?
Note - Some rows are just individual week numbers and do not contain either a comma or dash.
20-28, 33-35
20-24, 26-28, 33-34
Thanks in advance!
Tobermory