Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #801 Oct 09, 2012 www.energyefficientbuild.com.
user Adam Reed said: (http://productforums.google.com/forum/?zx=j1qokp4rhrrx#!category-topic/docs/spreadsheets/QA0TTfcnunc
Lowest Value in Row with Return
I have a row listing prices of items from various stores, using the MIN function I am able to find the lowest value, however, how can I tell what Column that came from so that I may return which store returned the lowest value?
----
https://docs.google.com/
There you are, thank you for your help!
-----------------------------------------------------------------------------------------
following is a single array formula solution to the problem
user Adam Reed said: (http://productforums.google.com/forum/?zx=j1qokp4rhrrx#!category-topic/docs/spreadsheets/QA0TTfcnunc
Lowest Value in Row with Return
I have a row listing prices of items from various stores, using the MIN function I am able to find the lowest value, however, how can I tell what Column that came from so that I may return which store returned the lowest value?
----
https://docs.google.com/
There you are, thank you for your help!
-----------------------------------------------------------------------------------------
following is a single array formula solution to the problem
No comments:
Post a Comment