Excel provides us with two formulas to generate random number those are, RAND() & RANDBETWEEN(). We can modify these functions to get random decimal numbers, random date, random time, random character. We can also calculate random text string to get a password. Well, there is a lot to do with this random function. In this section, we will discuss the steps to: RAND() Function … [Read more...]

In our earlier post, we have discussed the methods to create the drop-down list. In case, you need to edit dropdown list i.e. if you want to add more items to the drop-down list or you want to delete the items from the drop-down list you can do it with few pretty simple steps.  In this section, we will discuss the methods to edit the dropdown list. We will edit the dropdown list using the three … [Read more...]

It happens that many times we got stuck in an Excel workbook which contains duplicates cells. It is difficult to understand the data with duplicates. Well, we can delete duplicates in Excel. Let’s see how? In this section, we will first learn to identify the duplicates in Excel and then we will see how to delete the duplicates? We will also discuss the scenario when there are multiple rows … [Read more...]

Blank rows or cells in a table create a lot of confusion for excel built-in functions to identify the data in a correct manner. So, to clean the data in the table we must delete blank rows present in a table that creates a disturbance while analysing the data. Well, if you are working with a large table in Excel and you keep on adding or removing entries in a table, definitely there will be … [Read more...]

There can be two reasons to compare two columns in excel either we have to find the matches or to find the differences. Matches are the data points that are present in both the compared columns. Differences are the data points that are in one column but not present in other column being compared. There are several ways to compare two columns in an excel sheet. In this section, we will discuss … [Read more...]

Have you ever operated the function COUNTIF in Excel? COUNTIF is a statistical function which counts all the cells that match the criteria we describe in the function. This function always returns you a count number that has met the criteria specified in the function. Let us discuss the syntax of the COUNTIF function: COUNTIF(range, criteria) range: Here, the range denotes the range of … [Read more...]

It becomes messy to sort out the unique values in a large range of cells if it contains duplicate values. Let’s say if you want to identify or count unique values in excel, then you can build up your own formula for it. There are various functions available in Excel using a combination of which you can implement the formula to count the unique values in Excel. In this section we will discuss … [Read more...]

Excel provides various formats to display a date. It even allows you to change date format in a way you are comfortable with. Excel has defined the code for displaying the days, months and years using a combination of which you can format or customize your dates as you wish. In this section we will see how the dates are stored in excel, how can you change its format? How you can customize the … [Read more...]

We know various methods to calculate the percentage. Even the excel provides us with several ways to calculate the percentage. Percentage is a value that is a proportion, in relation to the whole data. We can calculate the percentage for certain marks in examination, or calculating % discount for various prices, the percentage change between two numbers and so on. For calculating percentage … [Read more...]

When you open an excel file that have macro or macros, a warning appears to enable macros in excel file. The macros are used to automate the tasks that the user needs to perform repeatedly. The macros are created by recording a sequence of commands over a cell in a file. The macro once created, can be run over any cell/cells when you have to perform the desired task. Most of the macros are … [Read more...]