circular reference

  1. A

    Problem with iterative formula - circular reference warning

    <colgroup><col><col></colgroup><tbody> I need help on this problem which (unintentionally) involves a circular reference. Major issues: "DIV/0" and "#N/A" (of course due to the circular). I'll prefer to eliminate the circular ref. but at the same time would prefer it to be solved by iterative...
  2. M

    How to bypass circular reference. Assigning holidays to staff schedule.

    Hey guys, I've been struggling with a problem for a few days, so decided to test the superior minds of MrExcel. If anyone can solve this, I'd be very grateful! Here's an example table for a staff schedule: <colgroup><col><col span="7"></colgroup><tbody> 5/5/2016 5/6/2016 5/7/2016 5/8/2016...
  3. W

    Schedule Model with Queing

    I am trying to build a scheduling model for a clinic. Right now I am focused on building the basic model (random variation elements will be added later). Eventually, I am hoping that I can show wait times for patients and resource utilization patterns based upon different scheduling templates...
  4. C

    SUMIFS formula in same column as the sum range (Possible?)

    I've been using this awesome forum for many years, getting all of my Excel questions answered by the awesome forum members and Excel gurus, but now I'm having a task to which I cannot seem to find an already existing topic/solution for, thus this is my first post. I'm having (almost) the same...
  5. I

    Equating Data in Two Cells?

    Hi, I have a list of data in Sheet 1, and I use =(VLOOKUP($M$4,'Sheet 1'!$A$3:L1002,6,FALSE)) in Sheet 2 to call a value. I'm wondering if there is a way so that if I edit the value in sheet 2, it updates the value of the data in Sheet 1? Would I create some kind of a circular reference or use...
  6. A

    Intentional circular reference

    Hi all, I've written up an intentional circular reference as I need two cells to be identical when a certain criteria is met. These cells are also editable by other uses, both cells are set to 0 by default, it is only when one cell is changed, the other one must change. Is there a way to...
  7. T

    circumvent circular reference

    Can I circumvent circular references in excel by using VBA code (or is there a better way to make a formula) to calculate currency? In this case I have 2 columns where one is USD the other is GBP. When I enter an amount into the USD column I want the GBP column calculate on the fixed exchange...
  8. P

    Circular reference not in status bar or error checking

    Hi all, I have perused the various threads on difficulty finding difficult-to-locate circular references, but it appears that everyone eventually finds the problem either in the Error Checking--> Circular References dropdown option, or in the status bar (near "Ready"). I have this error pop up...
  9. B

    Iterative Calculation Breaks Data Table

    Background: I have been working on a pretty typical financial model that requires a circular reference (i.e. the amount of debt for a project is dependent on total project cost, which is dependent on the amount of debt, etc.). So I have turned on iterative calculation to handle this. The...
  10. T

    Excel Macro - trapping Error Message when Opening Workbooks

    I have an Excel macro that opens workbooks in a folder/sub-folder structure and processes each worksheet via Copy/Paste SpecialValue and re-saves the workbook. As the macro processes hundreds/thousands of workbooks, there have been a few workbooks that have been "skipped". One reason for the...
  11. G

    Are (woeking) circular references no longer possible in Excel?

    Many years ago, in the days of Symphony, QuatroPro, and earlier versions of Excel, I used circular references extensively to collect results from different input data sets in extremely large and complex spreadsheets. You could base the selection of inputs and where result data would be stored...
  12. N

    Circular Ref error / Excel 2010

    Hello all, newbie questions for you involving Excel 2010. Have two cells that look at each other as conditional. A1 looks to see if A2 is >0 and if yes than A1 must be 0. A2 also looks to see if A1 is >0 and if yes than A2 must be 0. Only one cell can have a value greater than zero at any...
  13. P

    Help copying the contents of a changing cell to a another cell but only once and triggered by a change in another cell

    Ok, here is my problem I have a feed of live horse odds coming into a spreadsheet and the odds are changing from several hours before the race right up until the end of the race. What I need to do is to copy the odds of each horse at the start of the race. This can be triggered by another cell...
  14. P

    Circular Reference

    Hello, I have a sheet that simulates inventory levels at a store with deliveries for replenishment. I have the demand and leadtime be random so I am using conditions and INDIRECT multiple times. A circular reference error has appeared and I cannot trace it to solve it as Excel is showing me 6...
  15. E

    Is My Economic Model too Difficult for Excel to Handle?

    I'm trying to run a mathematical simulation of an economic model. I'm wondering what is the best structure to solve this problem, or whether I should consider purchasing Matlab instead. (I'm very poor and buying a Matlab program may be out of my budget since I'm not a student or associated with...
  16. W

    DnD Character Sheet Creator

    Hey how is everyone doing today I am actually new to this site, and still pretty new to excel. I am currently running a Excel '13 on a Win 7, as well as a Max OSX with Excel. I am currently working on a personal project where I am creating character sheets for RPG games like DnD and what not. I...
  17. C

    Non consistent results with circular reference and vlookup

    Hi, I have a circular reference with embedded VLOOKUP function which I solve using the iterative calculation. However the results that I get are not consistent: at the beginning both columns D and E produce the same result - then same implied rating and the same spread. However if I change...
  18. R

    Mysterious Circular Reference

    This is my first time to submit a question here; I hope I'm asking for help correctly. If not, please advise and forgive. I've encountered something in a co-worker's spreadsheet that has me baffled. A cell contains a simple number (in this case, 12). There are formulas dependent upon that cell...
  19. S

    Financial Statement Modeling - Managing Circular References Using Iteration

    Hello all, I am looking for someone with experience building company financial statement models that use circular references to link the 3 financial statements. I am building a 5-year long-range model and basically the model keeps "blowing up" despite the fact that I turned on the iteration...
  20. S

    Projecting an investment portfolio while also changing composition of assets

    Hi, I am setting up a financial portfolio model. I have current/static portfolio data as of today - so, a list of stocks, bonds, private equity. In excel, I am forecasting returns for the next 10 years, so each asset class (or row) will grow at a certain rate. The sum $ total will grow from X...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top