To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Not all sorts in Excel are alphabetical. Sometimes, you need to sort by an irregular set of terms, and when that happens, you need to create a custom sort. Here's how.

Microsoft Excel: How to Find Missing Numbers in a Sequence. Locating missing sequential numbers can be an arduous task when working with long lists of data. For example, you might want to locate ...

Excel offers built-in tools to arrange your dates in ascending order (oldest to newest) or descending order (newest to oldest). Here is how to sort by date in Excel. Prepare Your Data Make sure the ...

You may want to multiply cells or numbers in Microsoft Excel to analyze data. Here's what you need to know to do it.

Learn how to multiply numbers in single cell, multiply multiple numbers from several cells, multiply column of numbers in Excel.

However, Excel's random number functions are volatile, meaning they change constantly. In this article, I'll show you how to generate and fix random numbers and remove duplicates.