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