filter column unique for alphanumeric

[LUIS ANGEL]

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

 

[dallton]

Principal CS Ana;yst

If you create a pivot table with the data and put the column in question into the left hand pane. It will provide a unique listing of the data.

 

[Prince Kumar]

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

 

[LUIS ANGEL]

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

 

[Ron Rosenfeld]

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.

 

[LUIS ANGEL]

Thnx Ron, This works for me!! cheers

 

[Ron Rosenfeld]

Thnx Ron, This works for me!! cheers

Glad to help. Thanks for the feedback.