Skip to content

Tag Archives: Excel-functions

In Microsoft Excel, in order to find Nth Largest value (with duplicates), an array formula based on MAX and IF functions is used. First, we… Read More
In this article, we will see how we can combine multiple values, and use them as lookup criteria for searching specific value(s) in the excel… Read More
If you use programming languages, like python, you must have used a function called string slicing, which extracts a part of the string and can… Read More
The calculation of matrices is one of the most difficult numerical computation tasks. You may need to add values diagonally in a table when performing… Read More
Every day in business or any other field lots of information are there that are required to store for future use. For anyone, it is… Read More
In Excel, sometimes we want to sum up the values based on some specific text values. Such as the cells which have text written as… Read More
Excel is providing various types of sorting formats e.g. “sort A to Z”, “Sort Z to A”, “Sort by color” and “Sort by date” etc.… Read More
Excel is mostly about numerical, however, we often have data of text data type. Here are a few functions we should know to handle text… Read More
A prime number is a number that is greater than 1 and has no positive divisor other than 1 and the number itself. Approach: To… Read More
The CHOOSE function is technically part of Excel’s lookup function and can be incredibly useful. The CHOOSE function returns a value from a list using… Read More
If you start studying advanced EXCEL, you must have noticed that many formulas, even the most basic formulas, when used with other formulas use this… Read More
MS Excel is a spreadsheet developed by the company Microsoft. Excel provides various kinds of functions and we can insert the data in form of… Read More
In this article, we will look into methods for calculating time and time variance in Excel. In Excel, time is stored as numbers where day… Read More
Have you ever analyze any data? What does it mean? Well, analyzing any kind of data means interpreting, collecting, transforming, cleaning, and visualizing data to… Read More
Average a number expressing the central or typical value in a set of data, in particular the mode, median, or (most commonly) the mean, which… Read More