Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Yields Slow response
Hi
I have a data sheet with hourly recordings of 220 data points. I have a summary that retrieves the data for the monthly peak of point 78 (Col BA). I am using the following array formula copied across to populate the summary. =IF((ROW()-8794)<MONTH(NOW()),OFFSET($A$1,MATCH(MAX(IF((MONTH ($A$2:$A$8785)=(ROW()-8794)),$BZ$2:$BZ$8785)),$BZ$2:$BZ$8785,0),COLUMN()-2),"") I added the if on the beginning to keep from getting errors on those future months. I realize there are almost 2 mil cells in my range but the response is painfully slow. Is there anything that i can do to speed up this process. Thanks Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow response opening Formats? | Excel Discussion (Misc queries) | |||
Excel SLOW !! Response time ... | Excel Discussion (Misc queries) | |||
Excel 2003 Slow Response | Setting up and Configuration of Excel | |||
Slow Response time | Excel Programming | |||
Slow Response time | Excel Programming |