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

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

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

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.

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

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.