Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default filter column unique for alphanumeric

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default filter column unique for alphanumeric

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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default filter column unique for alphanumeric

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
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,045
Default filter column unique for alphanumeric

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.
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default filter column unique for alphanumeric

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


  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,045
Default filter column unique for alphanumeric

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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Alphanumeric Filter Criteria Graham H Excel Discussion (Misc queries) 5 June 30th 08 07:17 AM
Finding unique entries among two columns of alphanumeric data Bob Excel Worksheet Functions 10 October 23rd 06 02:40 PM
unique filter results in some non-unique records. Serials Librarian Excel Discussion (Misc queries) 2 May 26th 06 09:58 PM
Unique generated alphanumeric number gr8guy Excel Programming 0 January 18th 04 11:28 AM
Unique generated Alphanumeric No. eijaz Excel Programming 3 November 21st 03 11:07 AM


All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"