Jan 17 2019 06:04 AM
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)),"")}
Jan 17 2019 06:35 AM
Hi
Alternatives:
- Filter
- Advanced Filter
- Pivot table
- Power Query