BrutalLogiC
Active Member
- Joined
- Feb 26, 2006
- Messages
- 267
- Office Version
- 2016
- Platform
- Windows
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
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
