My idealist streak can't help but notice the 'convenience' that the intended solutions are to begin in row 2.
What happens if we change it so that we insist on the first result being in row 1?
Forgive me for appearing pedantic; obviously in practice we would quite happily choose whichever row we wish to begin our required list of solutions. It's just that, to me, there seems something slightly 'less than perfect' about a solution which is row-dependent.
It's for similar reasons that I've always felt a slight pang of distaste whenever I see the construction with MATCH(0,COUNTIF... for listing distinct entries from a range; inside I'm always wanting to ask the poster "But I want to list my solutions beginning in row 1!"
Anyway, sorry for spoiling the fun! After all, it's your challenge, not mine!
It's clear your point! And I Agree with you. The solution provided above taking the previous value for calculate the next one... maybe it's not the best thing, but the challenge says the shortest one. You have a entire post explain how we can do it, and amazing reply by Lori:
This is my fourth challenging question, and have a desire to continue, but I can not see friends here do not really like the questions or the answers.
For example, this challenge John Jairo V,One of the brightest people I know,
Gave the only possible answer, and I can not find a reason not to receive LIKE !
Need to know to compliment !
I will agree that no one has given a like (that includes you as you have replied but not pressed the button ) but that doesn't mean that no one likes the solution or the discussion that happens in a challenge.
What I did not understand why it is so important to "like" it using the like button? What if this forum did not have this feature? Will you still perceive that no one is appreciating it? MrExcel has this feature as well but you can't trace the like to the post and giver. Some other forums don't have it. Do not come to a conclusion on the basis of a forum feature.
Even within challenges, you will find that some challenges have attracted more replies than others. The reason is people find something interesting or relevant to share.