HarrySiers
Board Regular
- Joined
- May 27, 2015
- Messages
- 61
Dear forumers,
I am searching for a way to do the following:
A1 contains the following words:
Red Yellow Blue Magenta Green Black White Grey Pink Brown
I am looking for a formula that does the following:
Place in cells A1 through A55 the following words: Red Yellow Blue Magenta Green Black White Grey Pink Brown
AND
Place in cells B1 through B55 the following words in the order displayed below:
Red Yellow Blue Magenta Green Black White Grey Pink Brown
Red Yellow Blue Magenta Green Black White Grey Pink
Red Yellow Blue Magenta Green Black White Grey
Red Yellow Blue Magenta Green Black White
Red Yellow Blue Magenta Green Black
Red Yellow Blue Magenta Green
Red Yellow Blue Magenta
Red Yellow Blue
Red Yellow
Red
Yellow Blue Magenta Green Black White Grey Pink Brown
Yellow Blue Magenta Green Black White Grey Pink
Yellow Blue Magenta Green Black White Grey
Yellow Blue Magenta Green Black White
Yellow Blue Magenta Green Black
Yellow Blue Magenta Green
Yellow Blue Magenta
Yellow Blue
Yellow
Blue Magenta Green Black White Grey Pink Brown
Blue Magenta Green Black White Grey Pink
Blue Magenta Green Black White Grey
Blue Magenta Green Black White
Blue Magenta Green Black
Blue Magenta Green
Blue Magenta
Blue
Magenta Green Black White Grey Pink Brown
Magenta Green Black White Grey Pink
Magenta Green Black White Grey
Magenta Green Black White
Magenta Green Black
Magenta Green
Magenta
Green Black White Grey Pink Brown
Green Black White Grey Pink
Green Black White Grey
Green Black White
Green Black
Green
Black White Grey Pink Brown
Black White Grey Pink
Black White Grey
Black White
Black
White Grey Pink Brown
White Grey Pink
White Grey
White
Grey Pink Brown
Grey Pink
Grey
Pink Brown
Pink
Brown
Finally, it would be great if the formula would be easily adaptable, in such a way that it also works if another colour will be added to the colours in A1, for instance Red Yellow Blue Magenta Green Black White Grey Pink Brown Orange
I am searching for a way to do the following:
A1 contains the following words:
Red Yellow Blue Magenta Green Black White Grey Pink Brown
I am looking for a formula that does the following:
Place in cells A1 through A55 the following words: Red Yellow Blue Magenta Green Black White Grey Pink Brown
AND
Place in cells B1 through B55 the following words in the order displayed below:
Red Yellow Blue Magenta Green Black White Grey Pink Brown
Red Yellow Blue Magenta Green Black White Grey Pink
Red Yellow Blue Magenta Green Black White Grey
Red Yellow Blue Magenta Green Black White
Red Yellow Blue Magenta Green Black
Red Yellow Blue Magenta Green
Red Yellow Blue Magenta
Red Yellow Blue
Red Yellow
Red
Yellow Blue Magenta Green Black White Grey Pink Brown
Yellow Blue Magenta Green Black White Grey Pink
Yellow Blue Magenta Green Black White Grey
Yellow Blue Magenta Green Black White
Yellow Blue Magenta Green Black
Yellow Blue Magenta Green
Yellow Blue Magenta
Yellow Blue
Yellow
Blue Magenta Green Black White Grey Pink Brown
Blue Magenta Green Black White Grey Pink
Blue Magenta Green Black White Grey
Blue Magenta Green Black White
Blue Magenta Green Black
Blue Magenta Green
Blue Magenta
Blue
Magenta Green Black White Grey Pink Brown
Magenta Green Black White Grey Pink
Magenta Green Black White Grey
Magenta Green Black White
Magenta Green Black
Magenta Green
Magenta
Green Black White Grey Pink Brown
Green Black White Grey Pink
Green Black White Grey
Green Black White
Green Black
Green
Black White Grey Pink Brown
Black White Grey Pink
Black White Grey
Black White
Black
White Grey Pink Brown
White Grey Pink
White Grey
White
Grey Pink Brown
Grey Pink
Grey
Pink Brown
Pink
Brown
Finally, it would be great if the formula would be easily adaptable, in such a way that it also works if another colour will be added to the colours in A1, for instance Red Yellow Blue Magenta Green Black White Grey Pink Brown Orange