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:Belongs To RangeFilterVlookup

Let's talk


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


For General Queries & Technical Support


For Sale and Demos