Show column header in addition to min/max result

  • Thread starter Thread starter Tabbi
  • Start date Start date
T

Tabbi

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.
 
Thank you Don, I'll give that a try

You didn't post your formula. Have a look in the help index for INDEX

--
Don Guillett
Microsoft MVP Excel
SalesAid Software







- Show quoted text -
Click to expand...
 
Back
Top