yogi_Compute Address(es) Of Maximum Values In A Column And Then Offset From Maximum Values To Find Best Teams

                                          Google Spreadsheet   Post  #1449
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-26, 2013
question by Paul Kioko (http://productforums.google.com/forum/?zx=wh33mpxca23w#!category-topic/docs/spreadsheets/yZ_6v5HbWtc)
Finding the Row of a max value

I am trying to get an address(cell name) of the max value in a range. So what i have is

=Address(Row(Max(S1:S5)), Column(Max(S1:S5)))

After that i want to do a offset for a different value, but i can't get passed the one above as it says argument must be a range

---

Here is a copy of the spreadsheet:

https://docs.google.com/spreadsheet/ccc?key=0AlTJqZKyRi55dFF0MHRnSlo1bk9YaGpHN3N3RFVYUWc&usp=sharing

-----------------------------------------------------------------------------------------------------------------------------------------------