software

I've been building a huge data base and have run into a problem:

I have a set of data with record name, ancestor name, recorded
elevation, corrected elevation:
rec anc ele calc ele
1 root quot;quot; =j2
2 1 10 =j2
3 1 quot;quot; =j2
4 3 3 =j2
5 3 4 =j2

Then I set an array to look at a list of records, find all decendants,
and give max elevation in J2 ( 35 is on the end because I want my tree
to grow 35 at each node)

{=if(isnumber(c2),c2,max(if(b2:b4=a2,d2:d4,0)) 35) }

But if I fill this down I end up getting a circular reference warning,
and none of the elevations will calculate. When in reality it isn't
circular because the base elevations are already existant. the final
cells should look like this)

rec anc ele calc ele
1 root quot;quot; 74
2 1 10 10
3 1 quot;quot; 39
4 3 3 3
5 3 4 4

What can I do?--
rareremedy
------------------------------------------------------------------------
rareremedy's Profile: www.excelforum.com/member.php...oamp;userid=33130
View this thread: www.excelforum.com/showthread...hreadid=529424If D2 =J2 then there is a circular reference--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;rareremedyquot; gt; wrote
in message ...
gt;
gt; I've been building a huge data base and have run into a problem:
gt;
gt; I have a set of data with record name, ancestor name, recorded
gt; elevation, corrected elevation:
gt; rec anc ele calc ele
gt; 1 root quot;quot; =j2
gt; 2 1 10 =j2
gt; 3 1 quot;quot; =j2
gt; 4 3 3 =j2
gt; 5 3 4 =j2
gt;
gt; Then I set an array to look at a list of records, find all decendants,
gt; and give max elevation in J2 ( 35 is on the end because I want my tree
gt; to grow 35 at each node)
gt;
gt; {=if(isnumber(c2),c2,max(if(b2:b4=a2,d2:d4,0)) 35) }
gt;
gt; But if I fill this down I end up getting a circular reference warning,
gt; and none of the elevations will calculate. When in reality it isn't
gt; circular because the base elevations are already existant. the final
gt; cells should look like this)
gt;
gt; rec anc ele calc ele
gt; 1 root quot;quot; 74
gt; 2 1 10 10
gt; 3 1 quot;quot; 39
gt; 4 3 3 3
gt; 5 3 4 4
gt;
gt; What can I do?
gt;
gt;
gt; --
gt; rareremedy
gt; ------------------------------------------------------------------------
gt; rareremedy's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33130
gt; View this thread: www.excelforum.com/showthread...hreadid=529424
gt;

Not exactly a circ ref. I increased the iteration and max change, it
went through, just took longer.--
rareremedy
------------------------------------------------------------------------
rareremedy's Profile: www.excelforum.com/member.php...oamp;userid=33130
View this thread: www.excelforum.com/showthread...hreadid=529424It is a circular reference that is why you increased the iteration--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;rareremedyquot; gt; wrote
in message ...
gt;
gt; Not exactly a circ ref. I increased the iteration and max change, it
gt; went through, just took longer.
gt;
gt;
gt; --
gt; rareremedy
gt; ------------------------------------------------------------------------
gt; rareremedy's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33130
gt; View this thread: www.excelforum.com/showthread...hreadid=529424
gt;