This article describes the user with 3 possible ways to generate the possible combination of 3 or more available columns in Excel. The first example is based on using the user-defined formula, to generate the possible combination. The second example is based on the method to use the VBA code, to generate the required combination. While the last example is based on using the Kutool to generate the same data. All three methods are completely accurate and can generate valid and unique results. Example 1: To generate the combination of 3 or multiple columns in Excel by using the formula ... Read More

Sometimes we need to find the similar dates in dataset of multiple dates to identify the frequency of occurrence of any activity in a month/year or day. For this we have a formula in excel using which we can instantly find out the dates falling under a specific year and/or month even for a single day. We will be using the following two methods to identify the dates by month and year only from a dataset. Comparing adjacent dates by month and year only through a formula Finding dates by month and year only through Conditional Formatting Finding ... Read More

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 More

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 More

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 More

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 More

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 More

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 More

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 More

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 More