Random name selector

In this article we will learn how to pick the name randomly  from a list, so we will use the INDEX formula along with the ROUND, RAND and COUNTA form...

Sorting Numbers in Ascending or Descending Order in Microsoft Excel

To sort the numbers in ascending or descending order, we use the formulas “LARGE”, “SMALL” and “ROW” in Microsoft Excel. To sort in asc...

Excel Transpose function columns to rows

The Transpose function is an array function which is used to rotate the contents of columns to rows and rows to columns in Microsoft Excel. Microsoft ...

How to use the UPPER function in Microsoft Excel

The UPPER function in excel is used to capitalize all letters of a string. In this article, we will explore how you can use UPPER function to do some ...

Copy the contents of the previous row to the next row

Sometimes when the data increases, we need to copy the contents of the previous row into the next row. This code will help you do that easily. Option ...

Summing the Values of Cells Occurring at the Intersection of Ranges

Problem: Range A1:B5 contains numbers. We want a total value of the cells occurring at the intersection of the following ranges: 1. Columns A:B, ...

Personal Notes or Hidden Text in a Excel Formula

You can use your personal notes in a formula to remember the details of the figures getting calculated there. For example, if a hostel student rece...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube