Vasant Nanavati wrote...
Let's say the list is in a named range called "List".
If your "current" column begins in A1 and the "new" column begins in B1,
enter the following formula in B1:
=A1+MIN(IF(List=A1,List-A1))
....
An alternative,
=MAX(A1,MIN(IF(List=A1,List)))
which is a bit more explicit that it returns A1 when A1 is strictly
greater than any values in List.
|