Hello, I need help with this:
In the attached file, the black part is given, and the red part is what the formulas should return. The formula is picking the words from left to right as long as there are any, and when finished, it starts from the beginning again.
I want it to be possible to extend the formula to the right, so that the formula keeps filling the cells no matter how many columns there are. (But the number of "black" columns with given words is fixed).
Thanx in advance
Bookmarks