View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
F[_3_] F[_3_] is offline
external usenet poster
 
Posts: 12
Default Recording maximum and minimum

I have a spreadsheet in which a value is automatically imported into B2
each day.

I would like B3 to automatically show the maximum value ever reached in
B2 and, in B4, the minimum ever reached by B2. Could someone advise me
on how I might do this please.

TIA.

--
F
(Beware of spam trap - remove the negative)