S
Steve
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
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