Re: $$Excel-Macros$$ count unique values

*hi * all of these are goog_220687958array formulas The following formulas will return the number of distinct items in the range B2:B11. . The following formula is the longest but most flexible. It will properly count a list that contains a mix of numbers, text strings, and blank cells.

$$Excel-Macros$$ count unique values

Hi, i want to count unique values in a selection. I got this formula on net =SUMPRODUCT((B2:B30)/COUNTIF(B2:B30,B2:B30)) but i dont know how it works. So please help me understand this formula. -- -- Some important

Re: $$Excel-Macros$$ count unique values

Hi, Attach Some data ..and send will try.. *Best Regards,* *Venkat* * * On Mon, Jul 4, 2011 at 3:47 PM, airen airen1...@gmail.com wrote: Hi, i want to count unique values in a selection. I got this formula on net =SUMPRODUCT((B2:B30)/COUNTIF(B2:B30,B2:B30)) but i dont know how it

Re: $$Excel-Macros$$ count unique values

try this link http://www.exceltip.com/st/Counting_Unique_Numeric_Values_or_Unique_Data_in_a_List_/818.html Dave has explained it in detail On Mon, Jul 4, 2011 at 6:15 PM, Venkatesan c venkat1@gmail.com wrote: Hi, Attach Some data ..and send will try.. *Best Regards,* *Venkat*

Re: $$Excel-Macros$$ count unique values

try it... =sum(1/countif(B2:B30,B2:B30)) and press ctrl+shift+Enter -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Mon, Jul 4, 2011 at 3:47 PM, airen airen1...@gmail.com wrote: Hi, i want to count unique values in a selection.

Re: $$Excel-Macros$$ count unique values

Hi Airen, This is the beauty of SumProduct function. Below is the explanation:- If you evaluate the formula in parts, you will get following look:

Re: $$Excel-Macros$$ count unique values

Hey, try my attachment i think my formula is very simple so please try Regards, Santy C On Mon, Jul 4, 2011 at 10:13 PM, Haseeb Avarakkan haseeb.avarak...@gmail.com wrote: Hello, If you want to count the unique numbres in a range, use this with just Enter,

Re: $$Excel-Macros$$ count unique values

Hello AIren, Consider B1:B6 we have these values; B1=1 B2=1 B3=Blank B4=A B5=Blank B6=Blank =SUMPRODUCT((B1:B6)/COUNTIF(B1:B6,B1:B6)) Firstly take (B1:B6) This will check B2:B30 is blank or not, If it is blank will give FALSE, if not will give TRUE. So will get like this

Re: $$Excel-Macros$$ count unique values

Nice explanation Haseeb (HTH).. !! Regards, DILIPandey On Tue, Jul 5, 2011 at 12:34 AM, Haseeb Avarakkan haseeb.avarak...@gmail.com wrote: Hello AIren, Consider B1:B6 we have these values; B1=1 B2=1 B3=Blank B4=A B5=Blank B6=Blank =SUMPRODUCT((B1:B6)/**COUNTIF(B1:B6,B1:B6))