# Duplicate finder hangs

**URL:** <https://community.tiller.com/t/duplicate-finder-hangs/22906>\
**Category:** Google Sheets\
**Created:** [January 12, 2024, 6:09pm UTC](https://community.tiller.com/t/duplicate-finder-hangs/22906 "2024-01-12T18:09:14Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![Mark.S](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mark.s/32/14650_2.png) [@Mark.S](https://community.tiller.com/u/Mark.S)\
**Post date:** [January 30, 2024, 5:02pm UTC](https://community.tiller.com/t/duplicate-finder-hangs/22906/7 "2024-01-30T17:02:17Z")

</div>

To [Find Invalid Categories on Transactions Sheet](https://community.tiller.com/t/finding-invalid-categories-on-transactions-sheet/21750), use the following formula in a spare sheet cell with rows open below it.

`=SORT(UNIQUE(IFNA(FILTER(INDIRECT("Transactions!$D$2:$D"),ISNA(XMATCH(INDIRECT("Transactions!$D$2:$D"),INDIRECT("Categories!$A$2:$A"))),INDIRECT("Transactions!$D$2:$D")<>""))))`

Where Transactions `D` and Categories `A` are the Category columns of each sheet, respectively. Change these column letters in the formulas to match your spreadsheet, if they are different.

---

_[View the full topic](https://community.tiller.com/t/duplicate-finder-hangs/22906)._