I am new to Tiller and actively populating the Tiller workbook with data from “Money in Excel”. My question is: What is the easiest way to locate transactions which have a category taht does not exist or aligned with those entered in the Categories tab. Thank you

Uncategorized is easy, just enable Filtering and change the filter for the Category column to show only ‘(Blanks)’. To show ones that don’t align with existing Categories, the best I can come up with is to turn off all the existing categories in the Filter so all that remains are ones that don’t ex…

Thank you. The filtering selection at the top of the Transaction Category column appears to pick all data in the column so not clear if I can easily discern. All fields are filled with categories from the previous data, thus no empty cells. Also, if I try and filter without any selections, the proce…

I believe that by default if the category does not exist on the category sheet then a little red arrow will appear. This is because the transaction sheet uses a data validation rule that allows fills the drop down

Locating Unmatched Categories

Conversation Ask Anything

randy July 22, 2022, 10:58pm 5

I tried to answer this question for you here, @dmelideo.

Topic		Replies	Views
Best Way to Find Uncategorized Transactions? Ask Anything	2	677	August 2, 2022
Missing category dropdown on Transactions sheet Ask Anything	2	761	August 19, 2020
Some of my categories do not show up in Income & Expenses Breakdown Google Sheets	1	44	March 11, 2025
Missing Categories! Help Google Sheets	5	862	January 21, 2025
Help, Some of my categories do not show up in Income & Expenses Breakdown Ask Anything	1	36	March 11, 2025

Locating Unmatched Categories

Related topics