You are here Create unique list in Excel and Add-in A-Tools with BS_Unique Function

Create unique list in Excel and Add-in A-Tools with BS_Unique Function

There are many tools in Excel to filter the duplicate data, such as using the "Remove Duplicates" of "Data" function on the toolbar, or use VBA programming, SQL programming. Today, Bluesofts would like to introduce to you a method to use advanced function BS_Unique() in Excel and Add-in A-Tools to get unique data, this method is extremely simple, convenient, unlimited query row, allow sort the retrieved data in the order and name the output range.

Guide function BS_Unique

Video guide

Assuming that we have the sample data "Data" consists of duplicate numbers and letters.

You can follow these steps to get the list of non-duplicate data.

Step 1:Place the cursor in the first cell that you want to return the result, from menu A-Tools on the Excel toolbar, select "Extension Functions" -> choose "BS_Unique".

Table setting parameters on the screen is displayed as follows:

Step 2:Fill out the parameters according to following structure:

+ “RangeOrArray”: Range or array data needs to be filtered the unique list. We push F4 to fix the data range.

+ “SortType”: Ascending or descending. ("1" is ascending, "0" is descending (do not fill, software is defaulted is "1").

+ “Option”: Define name of data range, insert row, ... (optional). You can name the data retrieved by setting the parameter at “Option”: for example : Name = LISTUNIQUE

Step 3:Finalize by pressing "Enter" or "OK" to display results.

  • Result when we choose "SortType" is ascending, as we can see, the range is named automatically is "LISTUNIQUE"

       We also type the formula as following: =BS_UNIQUE($A$3:$A16,1,"NAME=LISTUNIQUE")


  • Similarly, result when we choose "SortType" is descending

       We also type the formula as following: =BS_UNIQUE($A$3:$A16,-1)

The output range is automatically named for us.

Hope the article helpful for you.

Download Add-in A-Tools