filter column unique for alphanumeric
 

Joly Holidays

I have a colum with alphanumeric that i would like to get the unique values.

What would be the equivalent to the sum(if(frequency formula for alphanumeric values in a column.

Thnx

Luis

filter column unique for alphanumeric
 

Hi Luis Angel,

Why r u not using remove duplicate option in excel it self.

this can be spoted in data tab and the select deta and click on remove duplicate
option

Regards
Prince


On Monday, December 31, 2012 9:50:55 PM UTC+5:30, LUIS ANGEL wrote:
Joly Holidays



I have a colum with alphanumeric that i would like to get the unique values.



What would be the equivalent to the sum(if(frequency formula for alphanumeric values in a column.



Thnx



Luis

filter column unique for alphanumeric
 

Hi prince,

The thing is that I need to leave the table as it is and I need the formula to just count the unique values in that column. But the column has alphanumeric values. I have the formula that works just with numeric values.

Any Ideas?

Rgds,

Luis Angel

filter column unique for alphanumeric
 

On Mon, 31 Dec 2012 08:20:55 -0800 (PST), LUIS ANGEL wrote:

Joly Holidays

I have a colum with alphanumeric that i would like to get the unique values.

What would be the equivalent to the sum(if(frequency formula for alphanumeric values in a column.

Thnx

Luis

From Pearson: http://www.cpearson.com/Excel/Duplicates.aspx

Entered with <ctrl<shift<enter

=SUM(IF(FREQUENCY(IF(LEN(B2:B11)0,MATCH(B2:B11,B2 :B11,0),""), IF(LEN(B2:B11)0,MATCH(B2:B11,B2:B11,0),""))0,1))

Adjust B2:B11 to represent your range of interest.

filter column unique for alphanumeric
 

On Tuesday, January 8, 2013 8:24:31 PM UTC-4, Ron Rosenfeld wrote:
On Mon, 31 Dec 2012 08:20:55 -0800 (PST), LUIS ANGEL wrote: Joly Holidays I have a colum with alphanumeric that i would like to get the unique values. What would be the equivalent to the sum(if(frequency formula for alphanumeric values in a column. Thnx Luis From Pearson: http://www.cpearson.com/Excel/Duplicates.aspx Entered with <ctrl<shift<enter =SUM(IF(FREQUENCY(IF(LEN(B2:B11)0,MATCH(B2:B11,B2 :B11,0),""), IF(LEN(B2:B11)0,MATCH(B2:B11,B2:B11,0),""))0,1)) Adjust B2:B11 to represent your range of interest.

Thnx Ron, This works for me!! cheers

filter column unique for alphanumeric
 

On Mon, 21 Jan 2013 11:12:03 -0800 (PST), LUIS ANGEL wrote:

Thnx Ron, This works for me!! cheers

Glad to help. Thanks for the feedback.