How to sort birthdays in Excel

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

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...
Function: GCD

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

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

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

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

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