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

SIP (Session Initiation Protocol) and XMPP (Extensible Messaging and Presence Protocol) are both communication protocols used to establish and manage real- time communication sessions between two or more endpoints, such as computers or mobile devices. SIP is mainly used for establishing and managing multimedia sessions over the internet, such as voice and video conversations. XMPP (Extensible Messaging and Presence Protocol) is a real-time communication protocol used for instant messaging (IM) and the exchange of presence information. Read this article to find out more about SIP and XMPP and how they are different from each other. What is SIP? SIP is ... Read More

Pentium and Xeon are Intel Corporation CPUs that are commonly used in personal computers and servers, respectively. While both CPUs are made by the same company, they are built for different purposes and have significant features. Pentium processors are designed for simple computer activities, whereas Xeon processors are designed for more demanding and specialised workloads. Read this article to find out more about Pentium and Xeon and how they are different from each other. What is Pentium? Pentium is a CPU family invented and manufactured by Intel Corporation. It is a brand name for a type of CPU found in ... Read More

MTP and MSC are two alternative data transfer technologies that are used to transfer data between a computer and a digital device, such as a mobile phone or an MP3 player. MTP stands for Media Transfer Protocol, and MSC stands for Mass Storage Class. Both techniques offer advantages and disadvantages, and which mode to choose will be depends on the user's individual needs. Read this article to find out more about MTP and MSC and how they are different from each other. What is MTP? MTP has the advantage of providing a more standard method of exchanging media files. This ... Read More

Computers perform operations based on the comments received. The set of commands or rules is sent and processed by the network protocol. In the network, there are different types of computers connected which may possess different hardware and software components. So, it is necessary to make the computer of different types communicate with each other using common rules set by the network protocols. So, we need to deal with the elements of network protocols to have data communication between the nodes of the network. Network Protocol Network Protocol provides a set of rules to be followed for data transmission in ... Read More

In a computer system, monitor is the most significant output device that conveys the information from computer system to the output world. When it comes to the types of computer monitors, then several types of display technologies are used, such as CRT (Cathode Ray Tube), LCD (Liquid Crystal Display), LED (Light Emitting Diode), Plasma Display, etc. In this article, we will discuss the important differences between CRT monitors and LED monitors. But before discussing the differences, let us first discuss the CRT and LED monitors individually. What is CRT Monitor? CRT stands for Cathode Ray Tube. CRT is one ... Read More