MrExcel Publishing
Your One Stop for Excel Tips & Solutions

filtering text in a spreadsheet


Posted by Paul Garbett on February 05, 2002 8:52 PM

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


Posted by Richard S on February 05, 2002 9:10 PM

Pivot Table (nt)