View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michael Michael is offline
external usenet poster
 
Posts: 791
Default Highest Value In A Range

Place this on cell A6

=MAX(K:D)
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Alectrical" wrote:

Hi

How can I find the highest value in the range "D:K" and place that value in
a cell ie "A6"

Thanks
Alec