Posted to microsoft.public.excel.programming

Kamal[_4_] Kamal[_4_] is offline

external usenet poster

Posts: 4

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Finding the largest match	XJSquared	Excel Worksheet Functions	9	July 19th 09 05:45 PM
finding the largest number from the last row and look up its name.	Jeff	Excel Worksheet Functions	5	February 24th 05 10:40 PM
Help with finding largest value	paula	Excel Worksheet Functions	2	February 6th 05 10:51 PM
Finding and Showing the Largest	arjcvg	Excel Worksheet Functions	1	October 29th 04 05:11 AM
Finding and Showing the Largest	arjcvg	Excel Worksheet Functions	2	October 29th 04 03:01 AM

All times are GMT +1. The time now is 08:58 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us