## Identifying the Duplicate Data in Excel sheet

In this tutorial, I will show you step by step of how to find the duplicate data in rows/columns. This is followed by steps for deleting the duplicate data.

Demos and Full Guide

## The MATCH function in Excel

The Excel MACTH function returns the relative position of the specified item from the given range of cells. This is how the MATCH function can be used:

Demos and Full Guide

## Using Excel AND function with IF

The Excel simple IF function enables us testing a condition and returns True or False value. For example, in a student mark sheet, if Marks is less than 40, its Fail. If marks are greater than or equal to 40,…

Demos and Full Guide

## What is the purpose of IFERROR function?

The IFERROR function enables us to trap and handle the errors that occur in functions or use it independently. You may display descriptive messages e.g. “0 is not allowed” etc.

Demos and Full Guide

## The List Count Function in Python

The Python count() function is used to return the occurrence of the given object in the specified list. For example…

Demos and Full Guide

## The IF function in Excel

The IF statement is generally taken as a decision making statement. In Excel, the IF is a function that enables us doing that.

Demos and Full Guide

## What is Excel VLOOKUP function (for dummies)?

the VLOOKUP in Excel is used to “look up” or find a value in a table. The V in VLOOKUP function stands for Vertical. That means the VLOOKUP function works for data organized vertically.

Demos and Full Guide

## The COUNTIF function in Excel

Use the Microsoft Excel COUNTIF function (a statistical function) that is used to count the number of cells for the given criterion.

Demos and Full Guide

## Python open() function to perform read/write operations in files

The Python open() function is used to open the specified file where you may perform reading, writing and other operations.

Demos and Full Guide

## The While and Do loops in VBA

The VBA while loop is used to execute the given statements as long as the condition is True. If the condition is false on first check, the execution moves out of the while loop.

Demos and Full Guide

## The For loop in Excel VBA

The VBA for loop is used to execute the group of statements for the given number of times.The for loop should be used if you know how many times a loop will run in advance.

Demos and Full Guide

## What is Java equals() method?

The Java equals() method is used to compare objects. The equals() returns true if this object is equal to the given object. Otherwise, it returns false.

Demos and Full Guide

## The VBA select case statement

The Select Case is another decision making statement in VBA that might be useful for scenarios where you have a single expression to evaluate that has several possible values.

Demos and Full Guide

## The VBA MsgBox function

In VBA, the dialog box can be created by using the MsgBox function. The MsgBox enables creating dialog boxes with many options. For example, a dialog box is displayed before quitting the application.

Demos and Full Guide

## The VBA if statement

In VBA, the if is a decision-making statement that is used to execute a block of code if a certain condition is true.

Demos and Full Guide