Return Low Value Month
Posted by Ian on February 27, 2001 12:37 PM
I have a detail spreadsheet (sheet2) that I need to return summary information to on a overview page (sheet2). The detail contains commission amounts for each month in, lets say ,C2:C13. I've set it up to return the high and low value for the year, but was looking for formula that would return the name of the high month and low month. These are located in A2:A13. As a side, the person I'm preparing this for would kill me if a pivot table showed up in the workbook.