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
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= 0AlTJqZKyRi55dFF0MHRnSlo1bk9Ya GpHN3N3RFVYUWc&usp=sharing
-----------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment