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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find an Alphanumeric in a column 3
Excel ALERT a duplicate of the match of two cells in two different columns... please 0
Need to flag the lead ID of any contiguous ID's from a sorted list of ID's. 5
Excel 4 characters alphanumeric data validation check on one excel column. 1
Alphanumeric Recognition 2
Matching Values to Enter New Value 2
Data validation, mandatory and restricted field length for excel vbs 10
Max-function with alphanumeric values?!? 6

Back
Top