Function: RAND

Function: RAND

by | Mar 15, 2019

The RAND function returns an evenly distributed random numbers greater than or equal to 0 and less than 1. In this guide, we’re going to show you how to use the RAND function and also go over some tips and error handling methods.Supported versionsAll Excel...
Function: SUBTOTAL

Function: SUBTOTAL

by | Mar 14, 2019

The Excel SUBTOTAL function returns the subtotal of the specified values. The function works like a combination of aggregation formulas of Excel, and allows you to determine the function with the use of a separate parameter. What separates the SUBTOTAL function from...
Function: COUNT

Function: COUNT

by | Mar 11, 2019

COUNT is a statistics function that counts the numeric values within the specified range. A common use case for this function is counting the cells that have numeric values. In this guide, we’re going to show you how to use the COUNT function and also go over some...
Function: MINIFS

Function: MINIFS

by | Mar 7, 2019

The MINIFS is a statistics function that returns the minimum value of only the cells that meet certain criteria. In this guide, we’re going to show you how to use the Excel MINIFS function and also go over some tips and error handling methods.Supported Excel...
Function: MAXIFS

Function: MAXIFS

by | Mar 7, 2019

The MAXIFS Excel function is a statistics formula that returns the maximum value of only the cells that meet certain criteria. In this guide, we’re going to show you how to use the MAXIFS function and also go over some tips and error handling methods.Supported Excel...
Excel UNIQUE Function: Spill Range Operator

Excel UNIQUE Function: Spill Range Operator

by | Feb 21, 2019

The unique function in Excel is a powerful tool for handling dynamic arrays and spill concepts. This functionality enables users to efficiently manage and manipulate data within Excel, enhancing the flexibility and effectiveness of spreadsheet operations. With the...
SINGLE Function

SINGLE Function

by | Feb 20, 2019

The Excel SINGLE function is a Lookup & Reference formula that returns a value using implicit intersection. In this guide, we’re going to show you how to use the Excel SINGLE function and also go over some tips and error handling methods. The Dynamic Array...
Pivot Table Alternative Using Formulas

Pivot Table Alternative Using Formulas

by | Feb 19, 2019

Excel’s Pivot Tables are very powerful in the sense that you can perform most data organization and analysis tasks on the fly. Although Pivot Tables have several advantages over using formulas for the same effect, working with Pivot Tables can be tricky in certain...
SEQUENCE Function

SEQUENCE Function

by | Feb 19, 2019

The SEQUENCE function is a Math & Trigonometry formula that generates a list of sequential numbers in the form of an array or range. In this guide, we’re going to show you how to use the SEQUENCE function and also go over some tips and error handling methods. The...