View Single Post
 
Old 08-26-2019, 08:48 AM
Pluviophile Pluviophile is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Oct 2013
Posts: 20
Pluviophile is on a distinguished road
Default Circular Reference - Getting Around It

I have a grid of 20x20 cells. I want to set a numerical value in a particular cell and then have all the other cells populate on the basis of 'Set the cell value to the maximum of the north, south, east and west cells minus 1'.

So it would look like the below, completed with 0s out toward the edges.

I tried populating each cell (apart from the one set with 20) with "=max(n20,o21,n22,m21)-1" (where n21 was the cell set with 20) but, of course, that gave me circular references all over the place.

Is there any way to do this?
Attached Images
File Type: jpg Image2.jpg (13.3 KB, 20 views)
Reply With Quote