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
Microsoft Technologies Articles
Page 26 of 175
How to Hide Error Values in Pivot Table?
In the article, the user will Hide the error values in the pivot table by using the PivotTable Option function. The source data typically contains one or more blank heading cells, which causes the pivot table error "field name is not valid" to show. Each column's heading value is necessary to make a pivot table. There might be some incorrect values in the pivot tables when you make them in Excel. Now, however, it's time to cover up these errors or substitute them with readable text. Example 1: To hide error values in pivot table in Excel by using ...
Read MoreHow to get or return column header based on specific row value in Excel?
This article contains an example to demonstrate the process of returning a column header from a specific row in excel. The provided is based on VBA code. The mentioned VBA code can successfully perform the required operation. To execute the code, firstly open the developer section, and then execute the code editor to write the required VBA code. Article contains stepwise explanations to justify the requirement of all the steps precisely and accurately. Column header is a simple term used to represent the main heading provided for any particular column. Example 1: To get or return the column header ...
Read MoreHow to get list of sheets names in Google sheets?
Google Sheets is a cloud-based spreadsheet program developed by Google. It allows users to create, edit and collaborate on spreadsheets online, in real-time with other users. Google Sheets is similar to Microsoft Excel but with added features that make it more collaborative and accessible. Users can create and format cells, import data from other sources, and use functions and formulas to perform calculations and analyze data. Sheets can also be shared with others for real-time collaboration and editing, making it a useful tool for teams and organizations. It can be accessed through any web browser and is available as a ...
Read MoreHow to get date of birth from ID number in Excel?
In this article the user will understand the process of generating the date of birth from the ID number in excel. This article provides a brief and an easy example to guide the user the way to generate the date of birth from the provided employee ID. Thus, to evaluate the date of birth the user needs to process the provided data in such a way that the date of birth will be evaluated effectively without any miss. The provided example uses the formula to calculate the date of birth from the provided ID number. Here, will be assuming that ...
Read MoreHow to generate random values based on assigned probability in Excel?
In this article, the user will understand how to generate the random data value based on assigned probability in MS Excel. One example is depicted where two simple formulas are used to generate the required results. Random data would be used in multiple experiments and studies, and to analyze the available trends and patterns. For this article, the focus is to generate random values based on an assigned probability. Example 1: To generate random value based on the assigned probability in Excel by using the user-defined formula Step 1 Consider the data set as shown below image: ...
Read MoreHow to fix/convert trailing negative signs to real numbers in Excel?
In this article, the users understand “How to fix/convert the trailing negative signs to real number in excel.” The problem is that Excel does not understand negative values. Excel does not perceive some cells as a negative number if you are adding up some cells and it seems to disregard those cells. There are several possible causes for this, but the main one is that Excel misinterprets your reference to a number. For a variety of causes, Excel cells may contain trailing negative signs that need to be fixed. There some solution to fix/convert trailing negative signs are ...
Read MoreHow to find / Select minimum data / value in a range in Excel?
The term "data range" refers to a single cell, a row, a column, or a group of cells that include one or more continuous groups of cells. The range statement designates a set of data values. You can use a range expression in Excel to define the data range to extract. The given problem statement which can easily solve by using the minimum function. To search for the minimum value, open a excel worksheet where large voluminous of data in the cells are presented. Users would have to gather them all up one by one and retrieving the minimum ...
Read MoreHow to find Value with two or Multiple Criteria in Excel?
This article thoroughly describes the array formula and depicts the advanced filter to find the value with two or various constraints in excel. The criteria range for an Excel advanced filter is a collection of worksheet cells where the data filtering rules are entered. There must be a particular layout for the heading cells and criteria cells in the criteria range. The vertical and horizontal lookup functions in Microsoft Excel are special functions, but experienced users typically replace them with INDEX MATCH, which is in many respects superior to VLOOKUP and HLOOKUP. It can search up two or more ...
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 More