If in one column of a given spreadsheet I have a selection of boys names, some of which are repeated many times. what is the quickest way that I can generate a summary sheet with all the boys names only repeated once and the count of how many times that name appears in the first spreadsheet ?
Reagrds
Desperate Paul
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.
Archive of Mr Excel Message Board
