All resources related to Miscellaneous for Excel and Google Sheets.

How to Solve the System of Equations in Excel

In mathematical terms, the system of equation is set of two or more equations having the same set of unknown variables like x, y, z where we need to find the values of unknown variables to solve these equations. To solve the system of equations, we can utilize functions and...

How to Show Sheet Tabs in Excel

When we open the Excel workbook, it contains several worksheet tabs like Sheet1, Sheet2, Sheet3 or the named worksheet tab like January, February, etc. Sometimes, we can’t see tabs, some or all of them, at the bottom of the workbook. We need to learn methods of how to make these...

How to Limit Number of Rows And Columns in Excel

By default, each worksheet contains more than 100,000 rows and 16,000 columns to input data. But it is rare to use all of these rows and columns. We can manage to make the maximum number of columns or the maximum number of rows visible and restrict the others to add...

How to Apply a Formula to Entire Column in Excel

Applying a formula is the most common task, but when we need to apply the same formula in the cells of an entire column, it becomes a tedious task. There are multiple ways to learn how to insert a formula for the entire column. Figure 1. Applying Formula to an...

Issue response time calculation

If you need to calculate a response time based on priority level, you can create a table with status and apply VLOOKUP. This tutorial will show you how to issue response time calculation with a detailed example. Formula =Xn+VLOOKUP(value, table, column, FALSE) Explanation In this formula, Xn represents any cell...

Get last entry by month and year

Do you want to get the last entry by month and year in Excel? There are large data piled up in Excel sheets. If you want a single entry, suppose the last one according to month and year. Here is a simple and easy guide for those who want efficient...

Flag first duplicate in a list

Figure 1. of Flag First Duplicate in a List Excel Function. Let's say we are required to mark/flag the first duplicate in a list of items, we can use the COUNTIF function to achieve this. In this tutorial, we will step through the process of flagging duplicate values in a...

Most frequently occurring number

While working with Excel, we can easily determine the most frequently occuring number in a data set using the MODE function. This step by step tutorial will assist all levels of Excel users in identifying the value that is repeated the most times in a range. Figure 1. Final...

Create Array of Numbers

We can use the ROW and INDIRECT functions to create an array of numbers, e.g. {1; 2; 3; 4}. The functions are mostly used in array formulas requiring a numeric array for processing. This post provides a guide on how to create array of numbers using the ROW and INDIRECT...

Change Negative Numbers to Positive

Figure 1. of Change Negative Numbers to Positive in Excel. In order to change negative number values into positive number values, we are going to use the Excel ABS Function. Generic Formula =ABS(number) The number component of the formula syntax us the specific negative number value which we desire to...