This column introduces PIVOTBY, a new Excel function that may let you say bye-bye to PivotTables.

Well-known functions like UNIQUE, COUNTIF, and SORTBY can be used with the spilled range operator to generate dynamic, sortable lists. Using a hash symbol (#)—also known as a spilled range ...

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

Microsoft Excel is an undisputed king when it comes to working with numbers and data. Whether you're a student or a working professional, you may be using Excel in your daily life to make calculations ...

I'm using xlwings to read in data from named ranges defined in an excel sheet. The objective is to create a dict containing a dataframe for each named range in the sheet. This works great with the ...

The UNIQUE function in Excel 365 is designed to extract distinct values from a given range of data.

Functions are built-in shortcuts for common calculations. The Unique function removes duplicates or extracts distinct items from a list.

Were you wondering about how to count unique values in Excel? We've got you covered with our guide that have everything you need to know.

If you are more comfortable with Microsoft Excel functions, you can compute these unique values through a combination of functions as well.