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
Computers Articles
Page 41 of 100
How to generate random character strings in a range in Excel?
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 MoreHow to generate all combinations of 3 or multiple columns in Excel?
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 MoreHow to match dates by month and year only in Excel?
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 MoreHow 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 MoreDifference between SIP and XMPP
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 MoreDifference between Pentium and Xeon
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 MoreDifference Between MTP and MSC
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