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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show which cell has MAX, MIN values? 6
formula to display the max (or min value) for an entire column, basedon value in an individual cell 1
Min and Max Function 4
Arrays, Dates & Blank Cells 3
Max; Min & Dates 2
MIN/MAX functions and reporting from a different column 11
max and min help. 5
MIN, MAX, MODE tec.... from an array??? 1

Back
Top