Hi All,

I have this array formula :

=IFERROR(INDEX('Master Dataset'!B$10:B$500,SMALL(IF('Master Dataset'!$A$10:$A$500<+$C$6,ROW('Master Dataset'!$B$10:$B$500)-ROW('Master Dataset'!B$10)+1),ROWS('Master Dataset'!B$10:'Master Dataset'!B10))),"")

But I think it is causing my spread sheet to slow down when opening and closing, can anybody suggest a different formula that is not in array format?

Cheers

Mac