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.....
It's all good fun nonetheless.

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.....

It's all good fun nonetheless.

Andrew
P.S. the real challenge would be returning the phrases in the order they are found in the phrase being examined!