Thread: [Solved] Collating data
View Single Post
 
Old 08-06-2010, 01:52 AM
mugezhn mugezhn is offline Windows XP Office 2007
Novice
 
Join Date: Jul 2010
Posts: 16
mugezhn is on a distinguished road
Default

How about making pivot table by choosing the inputted names as rows and count of the names as a column???? After you input a name you would just have to refresh the pivot table. (You just have to be sure that the ranges of the pivot table are large enough to cover all the possible rows)
Reply With Quote