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


Recent Posts


Database Table Indexing

January 03, 2020 bySwanand Nirgudkar

For an automated process any operation involving database is relatively expensive since it involves…

Continue Reading

Truncating Database Transaction Log

November 02, 2019 byNidhisha Shetty

Databases are usually in Full Recovery mode. This means that every transaction is retained in the…

Continue Reading

ActivityRunner Not Starting

October 11, 2019 bySwanand Nirgudkar

One may face issue while applying SheetKraft patch wherein ActivityRunner service refuses to start…

Continue Reading

Reshape instead of Fill-Down condition

May 02, 2019 bySaloni Gude

Originally published on Thu, 2 Mar, 2017 at 6:59 AM Fill is used to generate multiple values from an…

Continue Reading

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 & Technical Support

contact@quantumphinance.com

 

For Sale and Demos

sales@quantumphinance.com