Andrew Fergus
MrExcel MVP
- Joined
- Sep 9, 2004
- Messages
- 5,462
- Office Version
- 365
- 2021
- 2016
- Platform
- Windows
Re: June/July 2008 Challenge of the Month
Hi Emma
If you set the iteration to 1 (and keep pressing F9) you can watch how it progresses through the loop.
I also got to thinking about this yesterday - in particular my comment that you cannot loop using a formula. I (temporarily) forgot that you can by using a row() function in an array formula. I tried tweaking this to remove the helper cell, using a row() function and converting the formula to an array formula, but I got stuck and really should get on with my work.....![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
It's all good fun nonetheless.
![Thumbs up :beerchug: :beerchug:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f44d.png)
Andrew
P.S. the real challenge would be returning the phrases in the order they are found in the phrase being examined!
Hi Emma
If you set the iteration to 1 (and keep pressing F9) you can watch how it progresses through the loop.
I also got to thinking about this yesterday - in particular my comment that you cannot loop using a formula. I (temporarily) forgot that you can by using a row() function in an array formula. I tried tweaking this to remove the helper cell, using a row() function and converting the formula to an array formula, but I got stuck and really should get on with my work.....
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
It's all good fun nonetheless.
![Thumbs up :beerchug: :beerchug:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f44d.png)
Andrew
P.S. the real challenge would be returning the phrases in the order they are found in the phrase being examined!