Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
MS Excel Articles
Page 75 of 119
How to compare two numbers with decimal numbers in Excel?
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 is the method explained in this article. Compare Two Decimal Numbers with Formula Step 1 − Following is the sample data for comparing the decimal number. Step 2 − Now enter the below mentioned formula in C2 cell of Column C to compare the values of column A and Column B. =IF((FLOOR(A2, 0.01)-FLOOR(B2, ...
Read MoreHow to compare two columns for (highlighting) missing values in Excel?
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 how to implement this formula. Compare Two Columns for Missing Values with Formulas and Highlighting the Same Step 1 − We have taken the below sample data in different sheets for comparison having some common as well as different values. Here, we have taken some data in two separate columns and ...
Read MoreHow to compare numbers but allowing a tolerance in Excel?
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 values. For this, follow the below mentioned formula and steps. Comparing Two Numbers having a Specified Tolerance Value Step 1 − We have taken the following sample data for comparison. Step 2 − Enter the formula in C2 cell as mentioned below. This formula will return True for those values ...
Read MoreHow to compare adjacent cells with Conditional Formatting icon sets in Excel?
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 between price inflation etc. In this article we will learn how to put icons instead of number while comparing adjacent cells of a rows or columns in an excel file by using the following methods − Compare adjacent column cells with Conditional Formatting icon set in Excel Compare adjacent ...
Read MoreHow to highlight rows based on date in Google sheet?
In the article, the user will understand the process of highlighting the rows that contain date-type data within the Google sheet. There are several features available in the Google sheet such as conditional formatting, cell formatting, and many other features by using which users can perform the same required tasks. This article guide contains two examples, both the provided examples will allow the user to understand the way to handle the provided date data type effectively and efficiently. Both the provided examples are precise and accurate. To highlight rows that contain date-type data in the Google sheet: Example 1: ...
Read MoreHow to handle if cell contains a word, then put a text in another cell?
Excel is a famous spreadsheet-based tool, used to manipulate and process available data. For this provided scenario, the user needs sample string data, to check the presence of the required string. To solve the provided problem statement, the user needs to create a formula by using the search function. The search function will allow the user to search some specific data from the provided cell value, and to generate the results according to the presence and absence of data. Example 1: To handle a cell that contains a word, by putting data text in another cell by using the user-defined ...
Read MoreHow to get the same or first day of next month on a given date in Excel?
This article briefs learners about the way to generate the same or the first day of the next month from the provided date in Excel. This article contains a stepwise explanation for both the discussed practices. The first example allows the learner to obtain the same-day date of the next month, this means if they pass “12-03-2023” as input then the generated output will be “12-05-2023”. Next example, allow leaner to get the first day of next month. This simply means if the input date “15-04-2023” then the generated output should be “01-05-2023”. Example 1: To get same day of ...
Read MoreHow to get subtotals based on invoice number in Excel?
Calculating the subtotal of an invoice is an important component of an invoice. It allows the user to understand the total amount after putting in the total invoice amount. In this article, the learner is guided through the process of generating a subtotal of the provided invoice number. For example, if invoice 101 has three entries of 100, 200, and 300, then the calculated subtotal amount will become 600. In this article, the user implements the Subtotal value by using the formula, method. Example 1: To get subtotals based on invoice numbers in Excel by using the formula: Step ...
Read MoreHow to get row or column letter of the current cell in Excel?
Excel spreadsheet store data in table format. Every Excel sheet is made up of rows and columns. Rows are the horizontal record fields available in the Excel sheet. On the other hand, columns are the vertical record fields available in the Excel sheet. Row address values are represented by using numbers. While column data values will be represented by using the alphabet. Since row data is represented by using numbers, therefore, they are required to be get converted into an alphabet value. While column data is already available in the form of letters. Example 1: To get row letter ...
Read MoreHow to get month from week number and year in Excel?
This article briefs learners about the way to generate the month-from-week number and year in Excel. This article describes two strategies to achieve the required task. The first example guides the learner to use the predefined methods, in the form of user-defined formulas. The second method guides the learner about the use of VBA code. Please note that VBA is a programming language that can work only when written properly within a proper format. This article contains stepwise explanations for both the discussed practices. Example 1: To get month from week number and year in Excel by using the formula: ...
Read More