» Retrieving Unique Values From A List
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
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

Book Store:
Recommended Books:
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Wall Street Journal Guide to Understanding Money and Investing
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Microsoft Outlook 2002 for Dummies
- Seven Habits Of Highly Effective People
No comments have been submitted.


