While Function Without Using VB
 

Question,

Is it possible to write a while statement in excel without using VB?

Best Regards,

Tim

While Function Without Using VB
 

You'll need to post details of what you're trying to do, and someone may be
able to help you. Excel doesn't have a While function or statement, but you
can use array formulas to analyze each character in a string, which I s'pose
is similar to a while statement.

http://www.cpearson.com/excel/array.htm




"Tim H" wrote:

Question,

Is it possible to write a while statement in excel without using VB?

Best Regards,

Tim

While Function Without Using VB
 

BTW - looping through each character in a string is only one example, you can
also "loop" through ranges and do some analysis of each cell in the range.

"Tim H" wrote:

Question,

Is it possible to write a while statement in excel without using VB?

Best Regards,

Tim