I have solved my problem Thank www.contextures.com everything I need in
a PivotTable without using macros
www.contextures.com excellent!! thanks
2011/8/26 ChilExcel <chilexcel...@gmail.com>
> in the example I use:
> 1 advanced filter
> 2 Pivot table
> 3 and formula for count unique
>
> i need macro for all in summary table
>
> 2011/8/26 ChilExcel <chilexcel...@gmail.com>
>
>> Thx , I know all of the above
>>
>> my problem is to use all operations once
>> Sum, Count, and Count unique !!!
>>
>> all, not separated
>>
>>
>> 2011/8/26 NOORAIN ANSARI <noorain.ans...@gmail.com>
>>
>>> Dear Sandeep,
>>>
>>> Please see attached sheet for Example...........
>>>
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>>>
>>> On Fri, Aug 26, 2011 at 10:51 AM, <chhajersand...@gmail.com> wrote:
>>>
>>>> **Dear excelguru,
>>>>
>>>> Can u pls elaborate what is unique count?
>>>> And how it helps?
>>>>
>>>> Sent on my BlackBerry® from Vodafone
>>>> ------------------------------
>>>> *From: *NOORAIN ANSARI <noorain.ans...@gmail.com>
>>>> *Sender: *excel-macros@googlegroups.com
>>>> *Date: *Fri, 26 Aug 2011 10:49:39 +0530
>>>> *To: *<excel-macros@googlegroups.com>
>>>> *ReplyTo: *excel-macros@googlegroups.com
>>>> *Subject: *Re: $$Excel-Macros$$ Help to create summary table count
>>>> unique
>>>>
>>>> Dear ChilExcel,
>>>>
>>>> For Unique Count...............
>>>>
>>>> Use below function..with Ctrl+shift+Enter..
>>>>
>>>> *=SUM(1/COUNTIF(I1:I28,I1:I28))*
>>>>
>>>> --
>>>> Thanks & regards,
>>>> Noorain Ansari
>>>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>>>>
>>>>
>>>> On Fri, Aug 26, 2011 at 3:20 AM, ChilExcel <chilexcel...@gmail.com>wrote:
>>>>
>>>>> hi all
>>>>>
>>>>> Please help to create summary table with unique count
>>>>> Summary table need:
>>>>> unique count (repeated)
>>>>> sum all
>>>>> count all
>>>>>
>>>>>
>>>>> file attachment
>>>>>
>>>>> --
>>>>>
>>>>> ----------------------------------------------------------------------------------
>>>>> Some important links for excel users:
>>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>>> http://twitter.com/exceldailytip
>>>>> 2. Join our LinkedIN group @
>>>>> http://www.linkedin.com/groups?gid=1871310
>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>>
>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>
>>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>>> Like our page on facebook , Just follow below link
>>>>> http://www.facebook.com/discussexcel
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> ----------------------------------------------------------------------------------
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>>
>>>> --
>>>>
>>>> ----------------------------------------------------------------------------------
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>>
>>>
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> Visita ; http://sites.google.com/site/chilexcel/Home
>> Visita ; http://www.youtube.com/user/timextag41
>>
>>
>
>
> --
> Visita ; http://sites.google.com/site/chilexcel/Home
> Visita ; http://www.youtube.com/user/timextag41
>
>
--
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ; http://www.youtube.com/user/timextag41
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
