Select Page

## How to sort birthdays in Excel

Excel is rich in data sorting features - you have built in features like Sort and functions like SORT or SORTBY. However, these methods won’t work without some modification when you need to sort dates in Excel. In this article, we are going to show you how to...

## How to sort dates by month in Excel

Sorting is a crucial part of organizing data. Being everyone’s go-to spreadsheet tool, Excel thankfully offers various tools for sorting data like the sort feature and functions like SORT or SORTBY. However, neither of these approaches can really help you with...

## How to create an Excel summary table using UNIQUE and SUMIFS

SUMIFS like other …IF or …IFS function are great tools to aggregate data based on a set of conditions. The downside of this approach is that the criteria must be supplied manually, especially when you need to create a summary table. In this guide, we’re going to show...

## Function: GCD

The Excel GCD function is a Math formula that returns the greatest common divisor (GCD) of two or more numbers. The greatest common divisor of a set of values is the largest positive number that divides each number. In this guide, we’re going to show you how to use...

## How to filter by using a formula in Excel

Filtering data helps focusing on certain aspects of a data set. Excel has built-in features for this, an Excel formula for filtering data was not in the software’s scope until the introduction of dynamic array functions. In this guide, we’re going to show you...

## What’s New in SpreadsheetWeb 6.9

Microsoft has recently announced that they will be adding dynamic array formulas into Excel. This functionality is already available for a number of users on the Office 365 platform, but widespread release should be coming soon. Dynamic array formulas are the solution...

## Function: RANDBETWEEN

The RANDBETWEEN function returns a random integer number between the numbers specified. In this guide, we’re going to show you how to use this function and also go over some tips and error handling methods.Supported versionsAll Excel versionsSyntax RANDBETWEEN(bottom,...

## Function: RAND

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...

## RANDARRAY Function

The RANDARRAY function is a Math & Trigonometry formula that creates an array of randomly generated numbers. In this guide, we’re going to show you how to use the RANDARRAY function and also go over some tips and error handling methods. The Dynamic Array functions...