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
Articles by Shibanshu Manna
15 articles
How To Check Or Find If Value Exists In Another Column?
When working with a large array of cells, manually cross-checking if a specific cell value is repeated in another column in the spreadsheet can be difficult and lead to skewed results. Fortunately, there are several options in Microsoft Excel that allow you to do this quickly and efficiently. In a few simple steps in this tutorial, we demonstrate how to use the Excel functions like VLOOKUP and MATCH to cheack if a value from one column exists in any other column in a worksheet. Method 1 Finding If Value Exists In Another Column Using VLOOKUP Function As shown in the ...
Read MoreHow To Combine Date And Time Columns Into One Column In Google Sheets?
Many professionals use Google Sheets to keep a record of time and date for HR and other purposes. While manually entering the values can take a lot of time, you can use the in-built features in Google Sheets to combine values in one cell. With this tutorial, we tell you how to combine date and time values in separate columns into just one with 2 very easy techniques. These methods provide flexibility and convenience, enabling you to merge date and time information into a single column quickly. Follow the steps to learn a new skill today! ...
Read MoreHow To Combine Multiple Cells Into A Cell With Space, Commas Or Other Separators In Excel?
In Microsoft Excel, combining the contents of multiple cells into a single cell with separators like spaces, commas, or other characters can be a valuable data manipulation and analysis technique. This helps the user to create concatenated strings that bring together information from different cells in a structured manner. In this tutorial, we will explore two methods—the CONCATENATE function and the ampersand (&) operator—to combine cells with various separators. Using a simple example, we demonstrate how to combine multiple cells into one cell with space, commas, and other separators. Method 1: Using the CONCATENATE Function The ...
Read MoreHow To Combine Multiple Columns Into One Single Column In Google Sheet?
A useful technique for organising and analysing data scattered in different columns is to combine them to just one column. Whether you want to merge related information or create a consolidated view, Google Sheets provides powerful tools to accomplish this task efficiently. In this tutorial we will explore two easy methods to combine multiple columns into one single column. Method 1: Using FILTER and LEN Formula You can use the combination of Google Sheets FILTER and LEN formula to return a filtered version of your data set with the specific condition of combining them in just one column. ...
Read MoreHow To Check Or Find If A Cell Contains A Specific String/Text/Word In Excel?
One of the key content inputs in Excel is strings. Strings refer to a sequence of characters or text like letters, numbers, symbols, and spaces. An Excel string can also represent a name, address, description, or any other textual information. Excel treats it as alphanumeric data rather than just numerical data, enabling it to perform manipulations and operations as the user requires. Looking for a particular text or word in Excel is very easy if you know how to use the right function and where. With the help of 2 examples, we demonstrate how to use the SEARCH and ...
Read MoreHow To Combine Duplicate Rows And Sum The Values In Excel?
If you enter data from multiple sources in your Excel worksheet, you are likely to enter duplicate information. These duplicate entries of data sets would need to be consolidated in order to rectify the error. In a small dataset, duplicate values are easier to spot and correct; however, in a large dataset, the manual work becomes overwhelming and more prone to human error. Microsoft Excel has smart features which let you identify and sum the values of duplicate rows in a table. Read this easy tutorial to find out how to combine duplicate rows and add the values ...
Read MoreHow To Clear The Entire Sheet Or Specified Range In Excel?
Do you often encounter too much data and spend a lot of time selecting and clearing Excel sheets? If so, this tutorial will be helpful to you. When analysing elaborative Excel worksheets, removing non-relevant information often makes it easier to study them. This tutorial explains how to clear an entire spreadsheet and a specified range in MS Excel using two simple methods Method 1: How to Clear The Entire Sheet? This is an easy procedure. If you want to clear the entire sheet, you can use a keyboard shortcut or from the corner cell. We learn how to do ...
Read MoreHow to Check The Size of Each Worksheet of a Workbook?
It is commonly known that when you right-click on an Excel file, you can see its properties and size. But what about when you want to know the size of individual worksheets within the file? Accountants and data analysts maintain large Excel workbooks with multiple worksheets. Understanding the file size can help determine the best way to analyze it. Some might want to begin with the heavy worksheet, or some may start with the lighter one. It often turns out that one sheet takes up the majority of the space in the workbook. This tutorial explains how to identify the ...
Read MoreHow To Check If Time Is Greater Than Or Less Than A Specific Time In Excel?
"Lost time is never found again." Many organisations and professionals are looking for the best way to make the most of their time. Microsoft Excel has the necessary tools and functions to measure time quantitatively. Using an example dataset, we will demonstrate how to measure time against a specific time in Excel using two formulas mentioned in the steps. Find out how in the following steps. Method 1: Measuring Time with a Logical Function We use an example of 9 students who had to submit their assignments before 03:30 PM. Their submission time is recorded in the spreadsheet below. In ...
Read MoreHow To Check If Time Is Between Two Times In Excel?
MS Excel is handy when you need to keep track of your time and make the most of your resources. Suppose you want to find out how long it takes employees to complete an assignment. You can log the times in your spreadsheet and run a simple function to check if resources are being optimised or not. In light of the results, you can highlight which reports were submitted after the deadline. With two formulas, this tutorial demonstrates how to determine whether a specific time is within a particular range. Using the Nested “IF” Function A logical function, ...
Read More