What is a LET function in Excel? The LET function in excel is used to assign the name of the calculations of the result. This allows storing of intermediate results of some calculations, values, name of some functions defined inside a formula. These name only apply within the scope of […]
LinkedList in Java
November 17, 2024
Similar to Arrays in java Linked List is also a Linear data structure. In Linked List unlike arrays elements are not stored in a contiguous locations and they are linked to each other using references(pointers in memory), in Linked List each element has a reference pointing it to the next […]
Maximum Subarray Problem ( Kadane’s Algorithm) Dynamic Programming
November 17, 2024
Maximum SubArray Sum is the problem of finding the sum of contiguous subarray elements with in an array of numbers form arr[1…n] You might ask what is a subarray? SubArray is basically array within an array is called a sub array, as shown below 4, -1, 2 is the subarray […]
Two Pointer technique in Java
November 17, 2024
What is Two pointer technique? A two pointer technique is a technique where given a sorted array we have two starting points or two points of consideration as they both move towards the middle of the array being iterated over, the two pointer technique is a useful tool to utilize […]
Collections in Java
November 17, 2024
What is Collections Framework in Java? In Java collection is an object that represents a group of objects (such as the classic Vector class). A Collections framework is a unified architecture for representing and manipulating collections, enabling collections to be manipulated independently of implementation details. What is Collection Interface? The […]
Arraylist in Java
November 17, 2024
ArrayList class is based on the List Interface in java which is based on array data structure. ArrayList is widely used for its functionality and flexibility it offers. ArrayLists are resizeable list of array implementations of list interface. It implements all optional list operations and permits all elements incuding null. […]
Regular Expressions – I
November 17, 2024
A regular expression (shortened as regex) is an extremely useful way of matching common patterns and texts such as emails, phone numbers, URLs etc. almost all programming languages have a regular expressions library. It is widely used in text editors also to find patterns and replace string patterns that we specify in the […]
Excel TEXTJOIN Function
November 17, 2024
The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges. Syntax: TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) For example = TEXTJOIN(” […]
Intersect method (Excel)
November 17, 2024
The Intersect method is used to Returns a Range object that represents the rectangular intersection of two or more ranges. If one or more ranges from a different worksheet are specified, an error is returned. Syntax: expression.Intersect (Arg1, Arg2, Arg3, Arg4, Arg5, Arg6, Arg7, Arg8, Arg9, Arg10, Arg11, Arg12, Arg13, Arg14, Arg15, Arg16, Arg17, Arg18, Arg19, Arg20, Arg21, Arg22, Arg23, Arg24, Arg25, Arg26, Arg27, Arg28, Arg29, Arg30) expression represents a variable that represents an Application object in excel. Parameters: Name Required/Optional Data […]
JavaScript Map(), Reduce() array of objects
November 17, 2024
Functional programming techniques can help in making code easier to understand at a glance and read and test, Functional programming has been making quite a splash in the development world. Functional programming has its special lists of list operations they are exactly like array of things. The list items are […]