How do I find unique values from column without using FILTER Option of Excel?
A Amit Dhawan Oct 11, 2005 #1 How do I find unique values from column without using FILTER Option of Excel?
B Bob Phillips Oct 11, 2005 #2 You could flag them with a formula B1: =IF(COUNTIF($A$1:A1,A1)>1,"","X") and copy down -- HTH Bob Phillips Amit Dhawan said: How do I find unique values from column without using FILTER Option of Click to expand... 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 said: How do I find unique values from column without using FILTER Option of Click to expand... Excel?
P Peo Sjoblom Oct 11, 2005 #3 http://tinyurl.com/c9jvn -- Regards, Peo Sjoblom (No private emails please)
R Ron Rosenfeld Oct 11, 2005 #4 On Tue, 11 Oct 2005 05:03:01 -0700, "Amit Dhawan" <Amit How do I find unique values from column without using FILTER Option of Excel? Click to expand... You could download Longre's free morefunc.xll add-in from http://xcell05.free.fr/ and use the UNIQUEVALUES function. --ron
On Tue, 11 Oct 2005 05:03:01 -0700, "Amit Dhawan" <Amit How do I find unique values from column without using FILTER Option of Excel? Click to expand... You could download Longre's free morefunc.xll add-in from http://xcell05.free.fr/ and use the UNIQUEVALUES function. --ron
