## How to get a week start and end date based on a specific date in Excel? Updated on 08-May-2023 11:31:09
In this article, the user will learn how to obtain week start and end date based on a specific date in Excel. The two examples are depicted in this article. Both examples are based on the starting and end date of the provided week. The first example uses a formula to obtain the start and end date for the week. This example briefs the use of weekday and weekend methods to perform the same task. On the other hand, the second example will allow users to understand the use of VBA code. VBA code example also allows users to use ... Read More

## How to get the opposite of an ABS value in Excel? Updated on 08-May-2023 11:28:21
ABS in Excel stands for "Absolute Value". This function takes only one argument, as a cell reference or number directly, and then determines the required absolute value. This article guides learners about the process to generate the opposite of an ABS value in Excel by using the formula, and VBA code method. The formula method contains two basic formulas, to convert the value directly to the opposite value. While the VBA code method is a code-based method, that uses the VBA code to solve the provided task. Example 1: To get the opposite of an ABS value in excel by ... Read More

## How to get the next sheet name in Excel? Updated on 08-May-2023 11:25:01

## How to generate random positive numbers without duplicates in Excel? Updated on 08-May-2023 11:22:20
In this article, the user will learn the method to generate random positive numbers without duplicate values in Excel. This article briefs learners on two strategies to perform this same task. The first example uses VBA code to generate unique random numbers, while the second example will perform the same task by using the kutool. The main point to understand while performing a task is that a single task can be done in many ways. So, learners should know which one should be used to generate the results accurately and precisely. Example 1: To generate random number in excel ... Read More

## How to generate random character strings in a range in Excel? Updated on 08-May-2023 11:19:00
Random data can be identified as random values, used to obtain some results. It can be used to perform simulations, to understand the pattern of different system components. It is useful when a user requires a large data set to evaluate some common feature. This article allows the user to generate a random string with three possible methods. The first method is based on the user-defined formula, the second method is based on the use of VBA code, and the final third method is based on the use of kutool. Example 1: To generate random character string in a range ... Read More

## How to generate or list all possible permutations in Excel? Updated on 08-May-2023 11:15:12
Permutation can be defined as the arrangement of objects in a specific order. In this article, the user would understand the method of generating the permutation by using the VBA code. To do so, the user needs to open the code editor for VBA and after that simply click on the “OK” button. Finally, run the written code, and the permutation sequence will be displayed on the sheet normally. Refer to all the listed steps, to understand the complete method. Example 1: To generate or list all possible permutations in excel by using the VBA code Step 1 To understand ... Read More

## How to generate all combinations of 3 or multiple columns in Excel? Updated on 08-May-2023 11:12:40
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

## How to match dates by month and year only in Excel? Updated on 02-May-2023 15:03:10
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

## How to compare two numbers with decimal numbers in Excel? Updated on 02-May-2023 15:02:27
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

## How to compare two columns for (highlighting) missing values in Excel? Updated on 02-May-2023 15:01:50
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