Thursday, December 26, 2013

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

No comments:

Post a Comment