Order of balances is swapped. How to keep track/prevent?


I have named 2 ranges (single cells boxed in red in the screenshot) in my Balances sheet, so that I can call them in another spreadsheet easily. However, today, the order of my two checking accounts was swapped. And then the balances caused a mild heart attack while looking at my other spreadsheet. :slight_smile:

What determines the order of those balances? Is there a way to force it to not change? It has only happened once in the few months that I have been using Tiller, but I would prefer to keep it consistent.

I believe each area in the Assets and Liabilities is sorted by when the account was last refreshed, with the most current at the top. These lists are dynamic and will constantly change, so you won’t want to set a named range there. There are hidden columns (J-Y) that help feed the content you see. I believe those are sorted as well, so again, not a good candidate for a named range. I’m thinking you may need to use something like a vlookup or a query formula to look through the listing of accounts (probably the J-O list) and pull the balance for the one you’re interested in. This would allow you to deal with the fact that the order of the accounts is unpredictable.

1 Like

Roger that. I guess it had luckily (unluckily?) remained the same for a while.
I am using another sheet to match those rows and pulling cell data into a named range there dynamically now. Thanks!

1 Like