View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John Taylor John Taylor is offline
external usenet poster
 
Posts: 24
Default Using Count() in Dynamic Formula

Hello all,

I'm attempting to construct a 'dynamic' formula to find the maximum value in
a column of figures that will, over time, be added to.

Can someone please help me with a formula to find Maximum value in Column F?
I've been playing with variations of the following, but without success
(obviously):

=Max(F1:F&Count(F:F))

Regards,

John