• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula that loops

S

Suril

Member
There are ofcourse many ways in which one can loop in a vba.

However, sometimes I feel the need to use a loop in an excel formula without any vba. Is there any way to do this?
 
Hi Suril,

I am not able to understand correctly what you are looking at.
We can not use Loop outside VBA (experts please correct me if I am wrong).

Something closer to Loops is Array formulas.
If you want to know what is Array formula, please check the below link.

http://forum.chandoo.org/threads/what-is-array-formula.11607/

http://office.microsoft.com/en-in/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx

http://www.cpearson.com/excel/ArrayFormulas.aspx

http://www.mrexcel.com/articles/CSE-array-formulas-excel.php

Faseeh has given some links which will lead you to details about Array formula.

P.S. - Happy new year !
 
ThrottleWorks said:
Hi Suril,

I am not able to understand correctly what you are looking at.
We can not use Loop outside VBA (experts please correct me if I am wrong).

Something closer to Loops is Array formulas.
If you want to know what is Array formula, please check the below link.

http://forum.chandoo.org/threads/what-is-array-formula.11607/

Faseeh has given some links which will lead you to details about Array formula.

P.S. - Happy new year !
Click to expand...
Thanks for replying. I also thought on the same lines until I saw a Chandoo post regarding cascading formulas in which there is a mention to create a loop formula. Reading that just got me some hope!
 
Hi Suril,

If you describe what your problem is exactly and what you want to achieve, we might be able to come up with a solution which could suit you. Very often with excel I struggle solving a problem in a specific way, although a much easier solution exists...

Cheers,
 
Hi @Aurelie,

Nothing specific in my mind. Its just something I would like to use when I come across such a situation. I googled it and found out a specific question, the answer of which, in case positive, would be like nectar to me:

Is it possible to iterate (loop) a group of rows in Excel without VBA or macros installed? Google didn't yield anything helpful.

=IF('testsheet'!$C$1 <= 99,'testsheet'!$A$1,"") &
IF('testsheet'!$C$2 <= 99, 'testsheet'!$A$2,"") &
IF('testsheet'!$C$3 <= 99, 'testsheet'!$A$3,"") &
... and so on through !$C$40, !$A$40 ...
Click to expand...

Source: http://stackoverflow.com/questions/4939537/how-to-loop-in-excel-without-vba-or-macros

PS: Workarounds are fine and I use it often but thats not what I m looking for right now
 
Hi Suril,

Well, if copying a formula in a column testing certain conditions can be conisdered as a loop, then yes, it is possible. But I guess you know that already as you say you use workarounds. Honestly, without a concrete example I struggle finding something which could be useful for you. Hopefully other people on the forum already came accross similar problems and will be able to help you more...

Regarding the example you posted from stackoverflow, it looks like the person who posted the question wants all results in one cell. I would say that this is only possible with VBA, which is not very helpful for you I guess :(

Cheers,
 
In English - "All roads lead to Rome", but the more dramatic is definitely "More than one way to kin a cat"
 
You must log in or register to reply here.
Back
Top