How to show best and worst results over a range

[Colin Hayes]

Hi

I have a small puzzle :

In cells B6 to B17 I have the months of the year.

In cells E6 to E17 I have a series of numerical results , one for each
month.

I'm trying in G1 and G2 to show which month has the best performance ,
and which the worst.

The results in G1 might read 'Best : July' and G2 might read 'Worst :
August'.


Can someone help with this?

Thanks.

 

[Access Developer]

You appear to have posted a spreadsheet (Excel?) question in a newsgroup
devoted to the Microsoft Access database software product. You'd be better
served to re-post this in one of the newsgroups whose name begins with
microsoft.public.excel...

But, as a start, the Max and Min functions in Excel are likely to be your
friend. It's been so long since I did any significant detail spreadsheet
work that I'd be reluctant to try to say how you related the Max or Min
value to the corresponding month.

Larry Linson
Microsoft Office Access MVP