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 |
All times are GMT +1. The time now is 06:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com