Re: $$Excel-Macros$$ Duplicates in Pivot table - Help pls

2010-06-14 Thread Steven Dsouza
ards, > 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$$ Dupli

RE: $$Excel-Macros$$ Duplicates in Pivot table - Help pls

2010-06-11 Thread Saurabh Patel
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

$$Excel-Macros$$ Duplicates in Pivot table - Help pls

2010-06-09 Thread Steven Dsouza
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