TextJoin Formulas making sheet calculate slow

[ahuang3433]

Hi,

Anyway to modify these 2 formula's to make the sheet calculate faster?

[Fluff13]

Don't use entire columns, limit them to a reasonable size depending on your data like
=TEXTJOIN(", ",,UNIQUE(FILTER('Open ESR''s'!B$2:B$10000,'Open ESR''s'!F$2:F$10000=Analysis!A5)))

[ChemistB]

Try using a smaller range instead of the entire column. Decide what your max last row is and only carry your formula that far. i.e. B1:B5000.

[ahuang3433]

Thanks for the help. Worked out just fine.

[Fluff13]

Glad to help & thanks for the feedback.