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

Image2.jpg (13.3 KB, 22 views)

I know the thread is over a year old, but i only saw it yesterday and then i woke up at 1.30am thinking about it.

So here we are, Pluviophile. If you are still around & intrested...

Is this what you were after? fixed size at the moment

Attached Files

Circular Reference - Getting Around It_purfleet.xlsm (19.5 KB, 8 views)

I'm looking at it now...

Was it what you wannted?