Thread: [Solved] question in pictorial representation
View Single Post
 
Old 03-02-2012, 11:45 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
Use a pivot table and set the values field to calculate the MAX.
Attached Files
File Type: xls 2.xls (61.5 KB, 10 views)
Reply With Quote