Home

Reduce Multiple use of Array

Maulikbagadiya1988
Occasional Visitor

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

Hi

 

Alternatives:

- Filter

- Advanced Filter

- Pivot table

- Power Query

 

Related Conversations