Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-02-2012, 07:56 AM
gsrikanth gsrikanth is offline question in pictorial representation Windows XP question in pictorial representation Office XP
Competent Performer
question in pictorial representation
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default question in pictorial representation

data and output please find the attachment


highest will come with respect to L AND R
Attached Files
File Type: xls 2.xls (61.5 KB, 8 views)
Reply With Quote
  #2  
Old 03-02-2012, 11:45 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline question in pictorial representation Windows 7 32bit question in pictorial representation 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, 8 views)
__________________
Colin

RAD Excel Blog
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
question in pictorial representation Question jmsa7 Excel 3 12-13-2011 01:44 AM
ppt question fat PowerPoint 0 10-06-2011 01:33 PM
question in pictorial representation One to many and many to one question Girlie4 Excel 3 08-09-2009 08:02 PM
Need help with this question... lllDNYlll Outlook 0 05-04-2006 07:17 AM
Categories question & replying with attachment question glitzymama Outlook 0 03-15-2006 09:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft