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.
January 03, 2020 bySwanand Nirgudkar
For an automated process any operation involving database is relatively expensive since it involves…Continue Reading
November 02, 2019 byNidhisha Shetty
Databases are usually in Full Recovery mode. This means that every transaction is retained in the…Continue Reading
October 11, 2019 bySwanand Nirgudkar
One may face issue while applying SheetKraft patch wherein ActivityRunner service refuses to start…Continue Reading