Alternative to rows(unique(filter()))?

[RattlingCarp3048]

i have a document with about 45-ish columns full of formulas. All of them are simple vlookups or countifs or sumifs or a nested combination except for 2 columns where i have the rows(unique(filter())) formula. the calculation speed has dramatically decreased since adding this formula in (it was excellent before these 2 formulas), sometimes to the point where i have to close and reopen the document several times. is there an alternative way to count unique values without removing the duplicates that would help to increase the calculation speeds?

the raw data that these 2 formulas are calculating has about 30,000-ish rows. I cannot remove duplicates from the raw data and just need these 2 particular columns to count the rows if it matches the given criteria minus any duplicates. here are the 2 formulas:

ROWS(UNIQUE(FILTER(IHC!A:A,(IHC!M:M=Summary!B5)*((IHC!I:I="Open")+(IHC!I:I="Processing")))))

ROWS(UNIQUE(FILTER(IHC!A:A,(IHC!M:M=Summary!B5)*((IHC!I:I="Closed Out/Failed QC")+(IHC!I:I="Closed Out/Pass QC")))))

 

[Fluff]

Do not use whole column references, especially in array formulae, they will always drag your workbook down.
Use a range that is more than enough, without going over the top.

 

[RattlingCarp3048]

thanks fluff. sometimes its the small things that i forget to try. its back to regular operating speeds.

 

[Fluff]

You're welcome & thanks for the feedback.