Two Pointer technique in Java

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

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

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. […]

Excel TEXTJOIN Function

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)

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

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 […]

Excel formula to generate random strings.

Random texts are a great, they can be used as the filler texts where you want to show representational text. Or we can generate random text to use as password generator that is secure and hard to crack by notorious users using formulas in excel. You can use Excel formulas […]

Smart Contracts and Etherum Blockchain

What is Ethereum? Ethereum is an open source, globally decentralized computing infrastructure that executes programs called smart contracts. Ethereum  uses a blockchain to synchronize and store the system’s state changes, along with a cryptocurrency called ether to meter and constrain execution resource costs. The Ethereum platform enables developers to build powerful decentralized applications with […]