Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Alphanumeric Filter Criteria | Excel Discussion (Misc queries) | |||
Finding unique entries among two columns of alphanumeric data | Excel Worksheet Functions | |||
unique filter results in some non-unique records. | Excel Discussion (Misc queries) | |||
Unique generated alphanumeric number | Excel Programming | |||
Unique generated Alphanumeric No. | Excel Programming |