Show column header in addition to min/max result

[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.

 

[Don Guillett]

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

 

[Tabbi]

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 -

 

[T. Valko]

See this screencap:

http://img488.imageshack.us/img488/1575/file3qt3.jpg

 

[Tabbi]

Biff - you are a champion, it is just what I wanted, thank you.

Perfect!

Tabbi

 

[T. Valko]

You're welcome. Thanks for the feedback!