Hi Saurabh,

Thank you for your time and efforts..Yeah, it will suffice for the time
being..thanks again

Steve

On Fri, Jun 11, 2010 at 2:04 PM, Saurabh Patel <
saurabh.pa...@in.aegisglobal.com> wrote:

>  Is the attached resolution you want?
>
>
>
> *Regards,
> Saurabh Patel *
>
>
>  ------------------------------
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *Steven Dsouza
> *Sent:* Thursday, June 10, 2010 12:07 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Duplicates in Pivot table - Help pls
>
>
>
> Hi,
>
>
> I need some help with my query pls.
>
> I have a pivot table which contains a large volume of data. The problem is
> there are a number of names which duplicate at various points. Is there a
> way to find out the repeated names and check the values against each of
> them. I have attached a sample sheet copied from the pivot table as an
> example.
>
> Hope some one helps me.
>
> I have already used the below formula, but is there a way to get the values
> associated with the repeats in another column or the same column.
>
> IF(COUNTIF($B$2:$B$5000,B2)>1,"Dup","uni")
>
> Thanks
> Steven
>
> --
>
> ----------------------------------------------------------------------------------
> 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
>
>
> DISCLAIMER:The information contained in this electronic message and in any 
> attachments to this message is
>            confidential, legally privileged and intended only for the person 
> or entity to which this electronic
>            message is addressed. If you are not the intended recipient, 
> please notify the system manager and
>            you are hereby notified that any distribution, copying, review, 
> retransmission, dissemination or
>            other use of this electronic transmission or the information 
> contained in it is strictly prohibited.
>            Please accordingly also note that any views or opinions presented 
> in this email are solely those of
>            the author and may not represent those of the Company or bind the 
> Company. This message has been
>            scanned for viruses and dangerous content by Mail Scanner, and is 
> believed to be clean.
>            The Company accepts no liability for any damage caused by any 
> virus transmitted by this email.
>
>
>  --
>
> ----------------------------------------------------------------------------------
> 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
>

-- 
----------------------------------------------------------------------------------
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

Reply via email to