#1
|
|||
|
|||
Array Formula
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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
looking to persist and array or something | vthomeschoolmom | Word VBA | 1 | 09-16-2015 02:12 PM |
Insertbefore an array? help :( | n00bie-n00b | Word VBA | 21 | 08-21-2014 08:03 PM |
Excel simplify formula - array of sequential numbers | Wries | Excel Programming | 1 | 05-12-2014 08:32 AM |
Convert String Array to Integer Array from a User Input? | tinfanide | Excel Programming | 4 | 12-26-2012 08:56 PM |
Complex array formula | andrei | Excel | 9 | 02-03-2012 03:40 AM |