filter column unique for alphanumeric

  • Thread starter Thread starter LUIS ANGEL
  • Start date Start date
L

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
 
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
 
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
 
Back
Top