Wednesday, January 11, 2012

yogi_Extract The Max Value From A Comma Separated Values In Rows Of A Specified Column


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user lalunaselena said:
Example Data:
Column        A         B
Row         Date     Mins
1          1/1/12   1, 2, 4, 5
2          1/2/12   3, 1, 4, 6
3          1/3/12   2, 8, 10,
4          1/4/12   .5,
How do I search colB for max value... per cell? ...for all of colB?
Note: Sometimes cells in colB are empty.
------------------------------------------------------------
following is a solution to the problem