Hi,

I have a sample excel file which contains a lot of array formulas which has made the spreadsheet extremely slow. Is there a way to remove the array formulas from SHEET 1 convert them into normal formulas and still achieve the same result ?

If any one of can please help with it ?

The formulas which I want to convert are :

=IFERROR(INDEX(Detail!A3:A$1500,MATCH("Old Stock Issue",Detail!P3:P$1500,0)),"")

=IFERROR(INDEX($B$2:$B$1500,MATCH(0,INDEX(COUNTIF( $D$1:D1,$B$2:$B$1500),0,0),0)),"")

=IFERROR(INDEX(Detail!A3:A$1500,MATCH(TRUE,ISBLANK (Detail!P3:P$1500),0)),"")

=IFERROR(INDEX($F$2:$F$1500,MATCH(0,INDEX(COUNTIF( $G$1:G1,$F$2:$F$1500),0,0),0)),"")

=INDEX($G$2:$G$1500,SMALL(IF(H$2:H$1500=$K21,ROW($ G$2:$G$1500)-ROW($G$2)+1),COUNTIF($K$2:$K21,$K21)))

Many Thanks,
Biswajit