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

Already have an account? Sign in.


Sign in or become a Financial Modelling Handbook member to join the conversation.
Just enter your email below to get a log in link.

Subscribe to Financial Modelling Handbook

Don’t miss out on the latest financial modelling guides. Sign up now to get access to the library of members-only guides.