Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-12-2017, 07:39 AM
Macacidic Macacidic is offline Array Formula Windows 7 32bit Array Formula Office 2010 64bit
Novice
Array Formula
 
Join Date: Sep 2017
Posts: 10
Macacidic is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 09-12-2017, 08:11 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Array Formula Windows 7 64bit Array Formula Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 09-12-2017, 08:19 AM
Macacidic Macacidic is offline Array Formula Windows 7 32bit Array Formula Office 2010 64bit
Novice
Array Formula
 
Join Date: Sep 2017
Posts: 10
Macacidic is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Array Formula 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
Array Formula Excel simplify formula - array of sequential numbers Wries Excel Programming 1 05-12-2014 08:32 AM
Array Formula Convert String Array to Integer Array from a User Input? tinfanide Excel Programming 4 12-26-2012 08:56 PM
Array Formula Complex array formula andrei Excel 9 02-03-2012 03:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft