## How to compare two numbers with decimal numbers in Excel?

Richa Garg

Updated on 02-May-2023 15:02:27

918 Views

For example, if there are two columns of data having decimal numbers and we want to compare the values column wise, then we can do this using two methods in excel. Either by comparing only decimal values or the whole number. Let’s see how we can complete this activity. Following ... Read More

## How to compare two columns for (highlighting) missing values in Excel?

Richa Garg

Updated on 02-May-2023 15:01:50

278 Views

Often we have multiple sheets of dataset having similar values but not aware whether any value is missing or not. Manually checking each value will be a tedious activity. So for this we can use the below mentioned formula which will identify the missing values in no time. Let’s see ... Read More

## How to compare numbers but allowing a tolerance in Excel?

Richa Garg

Updated on 02-May-2023 15:01:23

425 Views

In this article we will learn how to compare two number having nearby values to each other with a specified tolerance value. However using the basic formula as =A1=B1 we can directly compare the values for the exact match but sometimes we need to compare the value upto a tolerance ... Read More

## How to compare adjacent cells with Conditional Formatting icon sets in Excel?

Richa Garg

Updated on 02-May-2023 15:00:04

300 Views

Conditional format icons are used for better data visualization in excel. It gives an instant data analysis to the viewer. For example, Icon sets can be used in the following scenarios; comparison of greater than, less than and equals to data item, comparison of highest temperature and lowest temperature, comparison ... Read More

## How To Compare Two Strings For Similarity Or Highlight Differences In Excel?

Richa Garg

Updated on 29-Dec-2022 14:52:25

3K+ Views

In this article, we will learn how to compare two adjacent strings in excel for identifying differences or similarities. Two methods have been explained in this article as mentioned below. Compare two strings for similarities using a formula. Compare and highlight two strings for similarities or differences using VBA Code. ... Read More

## How to compare two columns and delete matches in Excel?

Richa Garg

Updated on 29-Dec-2022 14:48:06

1K+ Views

If you want to compare two or more columns to find duplicate values, it can be done using a formula mentioned in this article. Many times, we come across a data set where values are entered repeatedly and required to be filtered. Let’s see how this can be achieved. ... Read More

## How to compare if multiple cells are equal in Excel?

Richa Garg

Updated on 29-Dec-2022 14:44:51

3K+ Views

To compare the values of two or more cells there are multiple formulas that can be used. For example, MATCH, If(A=B), EXACT, COUNTIF, etc. Here we will be learning the following two functions to find the exact match or where the formula will compare the strings without considering the case ... Read More

## How to compare dates if greater than another date in Excel?

Richa Garg

Updated on 29-Dec-2022 14:39:56

2K+ Views

If we want to compare a date in an excel sheet with all other dates available in the sheet, then manually doing this activity will be very tedious and time taking. For this activity, we can use a formula that may give the comparison in one shot. Let’s learn how ... Read More

## How to combine worksheets of same name into one worksheet?

Richa Garg

Updated on 29-Dec-2022 14:36:39

134 Views

It usually happens with huge data that we might get multiple workbooks having worksheets of same name. Due to this we need to check all the similar sheets to get any specific value related to that sheet name. In this article, we will learn how to merge the worksheets having ... Read More

## How to clear table formatting style without losing table data in Excel?

Richa Garg

Updated on 10-Oct-2022 14:20:39

2K+ Views

In this article, we will learn how to remove the table formatting in an excel file without losing the data. Sometimes the table formatting may hide some parameters based on some conditions and that may get lost while copy-pasting the data from one sheet to another. Let’s have a look ... Read More