UNIQUE function

The UNIQUE function replicates and extends Excel’s Remove Duplicates feature in formula form. The UNIQUE function allows us to return a list of unique values in a list or range. By default, the UNIQUE function will return multiple values, which will be placed in the neighboring cells (to the bottom and/or to the right). I.e., we are dealing with dynamic array formulas here.   The syntax of the UNIQUE function is as follows: = UNIQUE ( array ; [by_col] ;

Sort & Filter in Excel

How to insert or remove a filter Excel AutoFilter features enable us to quickly sort and filter, i.e., to quickly order, select from based on a criterion, or analyze tabular data.   Feature is available under both Home and Data ribbons, as Sort & Filter:   We can insert a filter by positioning ourselves in any cell that is a part of a table and using the Filter button:   This is what a table with an inserted filter looks

Top 10 lists in Excel

When analyzing large amounts of data in Excel, often the best approach is to retrieve the top (10) values. Consider the following example: This table contains all of the invoices from January 29th. There are 904 invoices for that day. The values in the invoice column are unique, as those are invoice numbers. The values in the user column are not unique, as some users have multiple invoices on that day, and the values in the team column are not