What I hope you have is a table of data, because that's the best way to work in excel for stuff like this.
then you have a visualisation sheet with just the names of your accounts, their budget, their weekly spend (all dragged in by xlookup for values and unique names from the account name), and then this quick icon set.
What I hope you have is a table of data, because that's the best way to work in excel for stuff like this.
then you have a visualisation sheet with just the names of your accounts, their budget, their weekly spend (all dragged in by xlookup for values and unique names from the account name), and then this quick icon set.