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

I suppose this formula is used to extract values from a range based on a common value?
If so, there is probably no alternative to an array formula except VBA using a filter .
Perhaps post a sample sheet ( go advanced - manage attachments) showing the formula and desired results

Edit perhaps setting calcs to manual?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hold the phone, I think I figured out what is going on. I think i have accidently formatted the entire worksheet (every row). I think this might be why I am having slow go issues.