While Function Without Using VB

T

Tim H

Question,

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

Best Regards,

Tim
 
J

JMB

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
 
J

JMB

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