Forum Discussion

Maulikbagadiya1988's avatar
Maulikbagadiya1988
Copper Contributor
Jan 17, 2019

Reduce Multiple use of Array

Hi All,

 

I am using the following formulla in excel atleast 2000 times. Becuse it is having array function the file is getting heavy. Can someone suggest me alternate formula please.

 

{=IFERROR(INDEX($U$6:$U$10000,SMALL(IF(ISNUMBER(MATCH($T$6:$T$10000,$AY6,0)),MATCH(ROW($T$6:$T$10000),ROW($T$6:$T$10000)),""),AZ$5)),"")}

1 Reply

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Hi

     

    Alternatives:

    - Filter

    - Advanced Filter

    - Pivot table

    - Power Query