View Single Post
  #3   Report Post  
Harlan Grove
 
Posts: n/a
Default

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.