Unique Value without using FILTER
 

How do I find unique values from column without using FILTER Option of Excel?

You could flag them with a formula

B1: =IF(COUNTIF($A$1:A1,A1)1,"","X")

and copy down

--
HTH

Bob Phillips

"Amit Dhawan" <Amit wrote in message
...
How do I find unique values from column without using FILTER Option of
Excel?

http://tinyurl.com/c9jvn

--
Regards,

Peo Sjoblom

(No private emails please)


"Amit Dhawan" <Amit wrote in message
...
How do I find unique values from column without using FILTER Option of
Excel?

On Tue, 11 Oct 2005 05:03:01 -0700, "Amit Dhawan" <Amit
wrote:

How do I find unique values from column without using FILTER Option of Excel?

You could download Longre's free morefunc.xll add-in from
http://xcell05.free.fr/ and use the UNIQUEVALUES function.


--ron