Array Formula

		Microsoft Office Forums > Microsoft Excel > Excel
Array Formula

FAQ

Thread Tools

Display Modes

09-12-2017, 07:39 AM

Macacidic

Windows 7 32bit Array Formula

Office 2010 64bit

Novice

Join Date: Sep 2017

Posts: 10

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

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