If you have a lengthy column of numbers that you need to multiply by a percentage, Excel includes tools to instantly apply the product to the entire range of cells in the column.

The column index number is the column in the table array from which to retrieve the value, starting with 1 for the first column.

Column Index Number: This is the column number in the table array from which you want to retrieve a value. The first column is 1, the second column is 2, and so on.

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

Random Sort in Excel You can generate random numbers in Excel and use them in conjunction with Excel's sorting feature to have Excel randomize a list of data.

You can multiply in Excel using a few different methods. It's easy to multiply two numbers in Excel, but you can also multiply many different cells and numbers together, or multiply a column of ...

Learn how to count the number of unique and distinct values in a column based on data in another column using array in Microsof Excel.

Learn how to combine Microsoft Excel’s ROW() and ROUNDUP() functions to create a flexible serial function that returns groups of consecutive values.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.