Belongs to Range is too Slow

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.