Microsoft Office Forums

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: 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
  #2  
Old 09-17-2020, 06:54 PM
Purfleet Purfleet is offline Circular Reference - Getting Around It Windows 10 Circular Reference - Getting Around It Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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
File Type: xlsm Circular Reference - Getting Around It_purfleet.xlsm (19.5 KB, 6 views)

Last edited by Purfleet; 09-17-2020 at 06:56 PM. Reason: ATTACHMENT
Reply With Quote
  #3  
Old 09-17-2020, 06:56 PM
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: 20
Pluviophile is on a distinguished road
Default

Quote:
Originally Posted by Purfleet View Post
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
I'm looking at it now...
Reply With Quote
  #4  
Old 09-19-2020, 01:19 PM
Purfleet Purfleet is offline Circular Reference - Getting Around It Windows 10 Circular Reference - Getting Around It Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Quote:
Originally Posted by Pluviophile View Post
I'm looking at it now...

Was it what you wannted?
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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:33 AM.


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