Showing posts with label Array Formula. Show all posts
Showing posts with label Array Formula. Show all posts

HOW TO CREATE UNIQUE DYNAMIC LIST WITH ARRAY FORMULA IN EXCEL

Create Unique List Using Array Formula

How To Create Unique list Using Array Formula


We have value in column A but all values are more than one. how we can remove duplicate value and create a dynamic list using array formulas.

Create Dynamic Unique List Using Array Formula

Input this formula
=INDEX($A$2:$A$26,MATCH(0,COUNTIF($B$1:B6,$A$2:$A$26),0)) and Press Ctrl + Shift + Enter

 Blank row In Data

Blank Row In Data Remove Using Array Formula

In case A7 rows are blank in database unique list show one blank row on B6. how we can solve it, it's very easy with ISBLANK function. 

=INDEX($A$2:$A$26,MATCH(0,IF(ISBLANK($A$2:$A$26),1,COUNTIF($B$1:B2,$A$2:$A$26)),0))


Watch Video For Easy Learning