Convert Index formulas to normal

[biswajitkar]

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)))

I have attached the file for your reference.

Many Thanks,
Biswajit