Prev: Lookup based on reference
Next: date of JPG photo file which is taken
From: newguy on 30 Apr 2010 10:53
I am trying to get around a circular reference on a worksheet by using
a Loop. I need to loop until 2 cells equal each other. However one
cell is based on the other hence the circular reference. My thought
was that I would just start with 1 increase the cell value by .01 let
the workbook calc see if they are equal and loop until they are. I am
not sure if this is possible or if this is the best way to accomplish
this.

Thanks
From: Homey on 30 Apr 2010 13:01
have you try goal seek on tools menu?

Also if calc resolve with enough calcs you can try set calc mode iteration
on.

"newguy" <rexbiggs(a)gmail.com> wrote in message
news:9f0d93b7-fc8c-40bd-a10b-05225f974972(a)o11g2000yqj.googlegroups.com...
|I am trying to get around a circular reference on a worksheet by using
| a Loop. I need to loop until 2 cells equal each other. However one
| cell is based on the other hence the circular reference. My thought
| was that I would just start with 1 increase the cell value by .01 let
| the workbook calc see if they are equal and loop until they are. I am
| not sure if this is possible or if this is the best way to accomplish
| this.
|
| Thanks

From: B Lynn B on 30 Apr 2010 13:28
Rather than spending the time it would take to write the code, I would put a
formula in a third cell dividing one of your two values by the other. Then
use the Goal Seek tool to make the third cell equal to 1 by changing the one
you want to change. Much quicker and easier than writing code, as much fun
as that is.


"newguy" wrote:

> I am trying to get around a circular reference on a worksheet by using
> a Loop. I need to loop until 2 cells equal each other. However one
> cell is based on the other hence the circular reference. My thought
> was that I would just start with 1 increase the cell value by .01 let
> the workbook calc see if they are equal and loop until they are. I am
> not sure if this is possible or if this is the best way to accomplish
> this.
>
> Thanks
> .
>
 | 
Pages: 1
Prev: Lookup based on reference
Next: date of JPG photo file which is taken