"select distinct" in Excel

Giganews Newsgroups
Subject: "select distinct" in Excel
Posted by:  Gusur (gusur.c…@gmail.com)
Date: Sat, 7 Mar 2009

Dear All,
Is there any similar formula which works like "select distinct" syntax?
For example, I have random data

          A
1  Apple
2  Orange
3  Apple
4  Mango
5  Orange

and the result should be

          B
1  Apple
2  Mango
3  Orange

Thanks

Replies