Prantick Bala

It is possible to make custom functions for calculation based on the color of the cells using the Microsoft Visual Basic for Applications (VBA). ...

Dataset Overview In our dataset we have data of different members of a club. Our dataset contains several blank lines. We will delete these empty rows by ...

Method 1 - Replace #N/A with Custom Text Search for a student whose name isn’t in the list, you want to show custom text such as “Not found”. Enter the ...

This is an overview of the INDEX function. The sample dataset contains 2 columns: Country and City. Method 1 - Using the INDEX ...

In our datasheet, we have Quarterly sales by different salesmen across different sheets. Now we want to calculate the yearly sales of different salesmen. For ...

There is no built-in function to calculate the years between a past or future date and today’s date in Excel. However, you can do it by applying a combination ...

Consider the following dataset with 10 days of sales data from two different salesmen. Each of them sold one car per day which is given in columns B and C. We ...

Method 1 - Combining MID, CELL, and FIND Functions to Insert the Sheet Name into Cell Value Consider the following dataset. We want to insert the Excel sheet ...

We have a dataset of the Sales Report of a Company. We will count one column if the values in another column meet certain criteria. Method 1 - Using ...

Consider the following dataset about different customers who have applied for a bank loan. We will find the last cell with data in a row. Method 1 - ...

The following dataset showcases Unit Production in column C and Per unit Cost in column D. The total per month is calculated in column E. To delete columns ...

  Part 1 - Calculating the Difference Between Two Dates in Excel We have the Starting Date of different projects in column C and the Ending Date in ...

  The Absolute reference locks the referred cell. If you use an absolute reference, the cell won’t change after dragging the Fill Handle. To create ...

To showcase copying sheets, we’re going to consider the following sheet named Dataset. We will copy this sheet to a new sheet. Method 1 - Using the ...

In Excel, merging multiple rows, columns or cells is a common task. However, the standard merging procedure only keeps data from the upper left cell. In this ...