How to check for duplicate row labels
Inconsistent labelling impedes model clarity. In a big model, it can be easy to lose track of what we have called things and for duplicates to creep in.
This is especially true when multiple people are working on the same model. It's helpful to check the complete list of labels in your model occasionally.
This is impossible to do manually.
The Productivity Pack includes a macro that will list all the unique labels in your model. This will allow you to check for inconsistencies and duplicates. This is not something that you will need to do often. However, it is helpful when reviewing the model and preparing it for release. This guide will show you to clean up your duplicates.
Download the demo model used for this section:
This post is for subscribers only
Comments
Sign in or become a Financial Modelling Handbook member to join the conversation.
Just enter your email below to get a log in link.