Calculating speed issue

[tola_ray]

Dear All, I have create array formula to capture sum up individual record which is meet the criteria as : =SUM(IF(FREQUENCY(IF((Risky_Type_F="High Risk")*(Date_Education_F>=StartDate)*(Date_Education_F<=EndDate)*(Type_KP_F="EW")*(Match_Edu_E_F="Yes"),IF(UUIC_F<>"",MATCH("~"&UUIC_F,UUIC_F&"",0))),ROW(UUIC_F)-ROW(Education!$L$1)+1),1))

There are around 50,000 record in table and while running this formula it takes a lot of time. anyone have other way to make it run faster?

 

[Fazza]

hello

Suggest you paste some sample data & explain in words the result you're after.

Excel has tools - like pivot tables - that are suited to efficiently working with well structured data (that is, set up in tables).

regards, Fazza