Belongs to Range is too Slow

Posted under tips on May 02 , 2019 by Upasana


Originally published on Thu, 16 Feb, 2017 at 1:12 AM

When working with a large size data, execution of any function which requires filtering using "Belongs to range" or "Does not belong to range" condition, can be very slow. This happens because the algorithm for such condition involves the checking the condition for each row and thus increasing execution time. As an alternative try doing a "Vlookup.SK" with the reference range as key and input data as values followed by filtering with either with "Not #N/A" or "Is #N/A" condition to get the result of "Belongs to range" or "Does not belong to range" condition respectively.


Tagged:SheetKraftFilter

Let's talk

Address

7th floor, Unit No. 701, C Wing, Kailas Business Park, S. Veer Savarkar Marg, Park Site, Vikhroli (W), Mumbai-400079.


Phone

+91 22 62362043


For General Queries

contact@quantumphinance.com


For Technical Support

contact@quantumphinance.com


For Sale and Demos

sales@quantumphinance.com

Thank you for your feedback.