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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies