 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2007Show column header in addition to min/max result
Hello everyone Every month I work out the max and min for a range of income types over the last 24, 18, 12 and 6 months. As well as displaying the max and min result, is there a way to also select which of the months was the max and which was the min so it can be displayed alongside the value? The month is the column header. You didn't post your formula. Have a look in the help index for INDEX  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Hello everyone > [quoted text clipped - 4 lines] > select which of the months was the max and which was the min so it can > be displayed alongside the value? The month is the column header. Thank you Don, I'll give that a try > You didn't post your formula. Have a look in the help index for INDEX > [quoted text clipped - 13 lines] > > - Show quoted text - See this screencap: http://img488.imageshack.us/img488/1575/file3qt3.jpg SignatureBiff Microsoft Excel MVP > Thank you Don, I'll give that a try > [quoted text clipped - 16 lines] >> >> - Show quoted text - Biff - you are a champion, it is just what I wanted, thank you. Perfect! Tabbi > See this screencap: > [quoted text clipped - 29 lines] > > - Show quoted text - You're welcome. Thanks for the feedback! SignatureBiff Microsoft Excel MVP > Biff - you are a champion, it is just what I wanted, thank you. > [quoted text clipped - 37 lines] >> >> - Show quoted text - |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.