Retrieving Unique Values From A List





Problem:

Column A contains a list of values, each of which may appear more than once.
We want to create a list in column B in which each value from column A may only appear once.

Solution:

Use the INDEX, MATCH, and COUNTIF functions as shown in the following Array formula:
{=INDEX($A$2:$A$8,MATCH(0,COUNTIF($B$2:B2,$A$2:$A$8),0))}

Note:
The first cell in the unique list (column B) must remain empty.
The formula should be entered in the second cell and copied down until the #N/A error is returned.

List_________Distinct List
Red
Blue_________Red
Green________Blue
Yellow_______Green
Green________Yellow
Blue_________#N/A
Blue Screenshot // Retrieving Unique Values From A List
Retrieving Unique Values From A List



Leave a Reply

Your email address will not be published. Required fields are marked *


+ two = 8

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>