View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kamal[_4_] Kamal[_4_] is offline
external usenet poster
 
Posts: 4
Default Finding the largest value

I have an excel sheet with 250 columns and 50,000 rows. My requirment
is to get the largest sum total of any 5 CONSECUTIVE columns and
divide that sum by 5. To get the largest value for any row I have to
do 246 iterations. To find the required value for all the rows it
would take lot of processing time. Is there any better way of doing
this?