Like this?
A B C D 1 Date Value 2 01/02/2009 30.53 3 01/05/2009 30.39min C3 and down: =IF(B3=MAX(B2:B4), "max", IF(B3=MIN(B2:B4), "min", "")) 4 01/06/2009 30.63max 5 01/07/2009 29.73min 6 01/08/2009 29.82max 7 01/09/2009 29.19 8 01/12/2009 28.53min 9 01/13/2009 28.58max 10 01/14/2009 27.64min 11 01/15/2009 27.66 12 01/16/2009 27.88max 13 01/20/2009 26.41min 14 01/21/2009 27.56max 15 01/22/2009 27.14min 16 01/23/2009 27.28
Bookmarks