Extract highest number
On Fri, 24 Jul 2009 05:19:01 -0700, Tech_Wolf
wrote:
Ok, in cell E3-Ex (as many cells as user needs), there will be imput along
these lines: Acidosis, severe [5], Anemia, moderate [3].
I need to somehow automatically extract the highest numerical value from
that imput and place it into cell G3-Gx, where from it will be operated on by
some math formulas.
Since these numbers are all relatively small integers, Lori's formula will work
well.
--ron
|