Arrey formula taking long time to calculate - any other way or MACRO can be built ??

[kedarlimaye87]

Hello Everyone,
i have excel file where i have raw data in "Current" tab and "Previous" Tab copy pasetd from respective original files.
in Current work tab, i pulled 5 perticulat columns from Current tab in column B-F and same is done in Previous Work tab.
in column I-L i have some Arrey formula in place which search for the Match condition formula.
On basis of results in those column i pull the data using Index formula from Previous Work file matching to current work file column B-F.

Using this arrey formula it is taking too much of time to calculate my excel file (around 3-5 mins) as i have kept the calculation mode as Manuall.

can anyone help me in reducing this time or providing me simple MACRO which can be RUN once i Copy the data in Current and Previous Tab.

any help is really appriciated.
also tell me how to attach file in this post???​

 

[nuked]

Look into the DSUM and DCOUNT functions - these are specifically designed for bigger-data, whereas SUMPRODUCT and/or array formulas are not.

 

[kedarlimaye87]

Thanks.
how should i send file to you?

 

[nuked]

Free download site => post link on here so other experts can help