Microsoft Office Forums Circular Reference - Getting Around It

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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
Novice
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, 6 views)
Reply With Quote
Reply

Tags
circular_reference

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


All times are GMT -7. The time now is 03:36 AM.


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