Although circular references can make Excel models more unstable, sometimes we really need to set up formula that will cause circular references.
I've found this video on YouTube that explains perfectly what are circular references in Excel, how to use them properly and and how can we fix them.
Always keep in mind that circular references in Excel should only be used as last resource.
No comments:
Post a Comment