Alternative to this array formula

BrutalLogiC

Board Regular
Joined
Feb 26, 2006
Messages
229
Hello I have workbook which is painfully slow and I'm wondering if there is a better way of doing the formulas below so I don't have to keep deleting them then reinserting them...

I tried restricting the range to J7:J1400 but it doesn't seem to make any difference

{=IFERROR(MEDIAN(IF(Data!$J:$J=Summary!B5,IF(Data!C:C=Summary!$K$4,Data!$N:$N))),"NO DATA")}
{=IFERROR(MIN(IF(Data!$J:$J=Summary!B5,IF(Data!C:C=Summary!$O$3,Data!$N:$N))),"NO DATA")}

any help please
 

Forum statistics

Threads
1,082,500
Messages
5,365,935
Members
400,863
Latest member
kimtid

Some videos you may like

This Week's Hot Topics

Top