Hi Dilip, I am also having same problem but slightly different from the below even i was also following same logic for getting the count of unique values, but the problem is have 5 pivots one down the other when i refresh every month it will give some popup "asking do you want to replace the content of the cells.............."( it is because the number of values have been increased). Then will go ahead & insert some rows every month and refresh pivot. This will makes me to estimate the number of rows to be inserted ? is there any formula for getting the count of unique values or other than the logic which you have suggested here below.
Please note that the souce data for pivot is around 50K. ---------- Forwarded message ---------- From: Dilip Pandey <dilipan...@gmail.com> Date: Wed, Sep 15, 2010 at 10:40 AM Subject: $$Excel-Macros$$ Re: unique Countif To: Manoj Kukreja <manoj.kukr...@planetsoft.com>, "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> You are welcome Manoj...!! :) Best Regards, DILIPandey On 9/15/10, Manoj Kukreja <manoj.kukr...@planetsoft.com> wrote: > Thanks Dilip. > > -----Original Message----- > From: Dilip Pandey [mailto:dilipan...@gmail.com] > Sent: Tuesday, September 14, 2010 10:56 PM > To: excel-macros@googlegroups.com > Cc: Manoj Kukreja > Subject: Re: unique Countif > > Hi Manoj, > > Please find the solution attached with this email. > > Note:- Going forward please mark Group as well so that every one gets > equal chances of learn and to help others :) > > @ Group:- I have also attached the original query (image003.png) in this > email so that all can understand the query. > > Get back in case of any confusion. :) > > Thanks & Warmest Regards, > DILIPandey > > > > On 9/14/10, Manoj Kukreja <manoj.kukr...@planetsoft.com> wrote: >> >> >> > > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Regards, praveen -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
