MrExcel Publishing
Your One Stop for Excel Tips & Solutions

removing duplicate information

Posted by jason on October 01, 1999 9:38 AM

i have a large, regularly updated table that contains both columns of numbers and columns of text. i want to be able to have seperate data sheets that would automatically generate, for example, the number of times each seperate year was used, number of times each product line was used, etc..

can this be done in a macro?

Posted by Dave Stimpson on October 01, 1999 12:49 PM

Sounds like you need to generat summary info - see some of the tips on PIVOT Tables in the tips in Select the Year and Product fields and choose count as the operation. I will send an example of Pivot tables to your E-Mail