filter column unique for alphanumeric

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
 
P

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
 
L

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
 

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
Excel 4 characters alphanumeric data validation check on one excel column. 1
Need to flag the lead ID of any contiguous ID's from a sorted list of ID's. 5
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

Top