Duplicate finder hangs

To Find Invalid Categories on Transactions Sheet, use the following formula in a spare sheet cell with rows open below it.


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.