Thread: Please help
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
robert111 robert111 is offline
external usenet poster
 
Posts: 1
Default Please help


A pivot table would allow you to filter for all kerrybeniston1's. The
fields in your second column would be in the pivot table rows, eg
11kerrybeniston, 17kerrybeniston etc etc.

use the large worksheet function to find the biggest field in the list,
it might be obvious anyway if you sort the data "descending" in the
pivot table.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=562628