Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHPIn this article we will learn how to compare values of two columns to get the values from the third column. For example, we have taken a column with Class Names and along with each class name, student name has been written in another column. Now, we will get the students name in another column against some randomly taken class names. Let’s see how this can be achieved using an excel formula. Compare two columns and getting value from third column with VLOOKUP function Step 1: We have taken the following sample data for comparison. Step ... Read More
For instance, we have two columns in a data set having some names. And now we want to identify what names are repeating in either list. For this, we can apply a formula in two other columns, to get the unique values of both the columns. Let’s see how we can achieve this. Compare two columns and list differences with formulas Step 1: We have taken the following sample data for comparison. Step 2: Enter the formula in E2 cell as mentioned below. This formula will return the unique names of column 1, which are not ... Read More
When we have a bunch of data and need to compare rows and columns to maintain uniqueness then we might need to apply multiple formulas to the dataset. For instance you have two or more columns and want to compare the values of each row of all columns and return Yes or True of they get matched completely. This can be achieved using the below steps. Compare two cells of two columns and return yes if they are perfectly Matched using Formula Step 1: We have taken the following sample data with some random details. After comparing each ... Read More
Many times, we need to compare and identify the duplicate entries available in various columns of the excel data. Searching the duplicate entry of each value one by one is a tedious task. This can be achieved through a formula combination of excel sheet. Let’s see how the same can be achieved using the below steps. Compare alphanumeric values in two columns to find the same duplicates 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 Duplicate for those ... Read More
In this article we will learn how to remove specific cell contents while opening or closing an excel workbook. This activity can be done through VBA codes that can be applied individually at a time. Either on closing the file or opening the file. This feature can be useful when you have performed some calculations or analysis at a specific range in the workbook and want the same to clear as soon as you close the file or open the file next time. Let’s see how the VBA code can be applied. Clear Specified Cell Contents on Workbook Open ... Read More
In this article we will learn how to remove the values of specific cells if value of any linked cell gets removed or modified. This can be done using a VBA code. For example you want to clear a range of cell values if the value of a specified cell is removed or changed, then follow the below steps for the same. Clear specified cell contents by changing the value of another cell Step 1: Following is the sample data where on changing the value of A2 cell, the values of C1:C3 will get cleared. Step ... Read More
In HTML, the RGB i.e. (red, green, and blue) specifies the shades or intensity of the color with a value between 0 and 255. The RGB color model has a total of 256 x 256 x 256 = 16777216 possible colors. By adjusting the RGB values we can come up with different shades of colors, following are a few examples − Let’s say we want a “black” color, set all the parameters as, rgb(0, 0, 0). If we want to display a “white” color, set all the parameters as, rgb(255, 255, 255). If we set the parameters as rgb(255, ... Read More
The hyperlinks, which are also known as links, are crucial components in websites nowadays. These are clickable and can be used to navigate between source webpage to different pages or the sections in the same webpage. In most of the websites, the links will appear as underlined and differently colored. Links are categorized into the following types − Unvisited Links Visited Links Active Links Let’s discuss about the links mentioned above with suitable examples further in this article. Unvisited Links In HTML, an unvisited link is a hyperlink that is not yet clicked by the user. By default, ... Read More
In an excel workbook, we have the provision to set the print area (which we want to print instead of the complete workbook) from a sheet. In this article we will learn how to remove the print area if there are multiple sheets and all have predefined print area. This can be done automatically by using the Visual Basics Applications for Excel. Follow the below steps for the same. Removing Print Area of a complete Workbook using the VBA Code Step 1: Below is the sample data with two different sheets having predefined Print Areas. ... Read More
In this article we will learn how to remove the filters applied on various sheets of a workbook. Many users apply filters on the sheets to view the desired data and later save the file as is without removing the filters. This may create confusion for the user while opening the file again, as he might forward the filtered data to someone else for reporting or analysis purpose and the complete details might get missed. Please follow the below steps to perform this activity. Clear all the filters of a worksheet with a VBA Code Tip*: The filter ... Read More