Forum Discussion
Maulikbagadiya1988
Jan 17, 2019Copper Contributor
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...
Detlef_Lewin
Jan 17, 2019Silver Contributor
Hi
Alternatives:
- Filter
- Advanced Filter
- Pivot table
- Power Query