Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 08-26-2019, 08:48 AM
Pluviophile Pluviophile is offline Circular Reference - Getting Around It Windows 7 64bit Circular Reference - Getting Around It Office 2010 64bit
Circular Reference - Getting Around It
Join Date: Oct 2013
Posts: 18
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, 7 views)
Reply With Quote


Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
circular reference riothecat Excel 6 06-29-2017 10:56 AM
Circular Reference - Getting Around It Why does the circular and U Turn arrow only go left to right? Cerdic PowerPoint 1 10-22-2013 07:16 PM
Circular Reference - Getting Around It Circular Reference Warning in Excel Sheet. Rahmat_uk20 Excel 3 06-08-2012 02:31 AM
Circular Reference Errors BecciJane Project 2 06-01-2011 03:11 AM
Circular error markg2 Excel 2 05-17-2010 07:39 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 02:34 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd. is not affiliated with Microsoft