#### melodramatic

##### Board Regular

- Joined
- Apr 28, 2003

- Messages
- 171

- Office Version
- 365

- Platform
- Windows

I've got approximately 10,000 rows of data on a sheet called "Data". This data is strictly numeric, run through an equipment logger into columns of channels. Each row comprises one minute, and I batch them into cycle numbers (roughly anywhere between 1500 and 3000 rows of data per cycle).

On my sheet called "Stats", I have a grid where I mark if a certain channel is malfuncting per each cycle. As a note, there are 5 cycles per file.

My third involved sheet is "Calc." What I'm doing here is telling the system to look at the cycle number for that row (in Col B)

THIS CALCULATION COMES FROM Calcs!R19 (channel 14). The cycle number found in Column B is 71. I want to check the Stats page to see if Channel 4 is malfunctioning during Cycle 1 (all malfunctioning boxes are marked with a "1"). If the channel is not malfunctioning, I want to pull in the value of the corresponding cell on the Data page (Data!R19). If the channel IS malfunctioning, I want to enter the value "0".

=IF((MAX(IF(Stats!$A$7:$A$11=$B19,Stats!R$7:R$11)))=1,0,Data!R19)

The calculation works fine. HOWEVER, I need to do about 16 columns, 10000 rows of this calculation. Right now, it has allowed me to copy the calculation down to row 6124, and then it won't copy anymore.

Will shortening my formula help me be able to carry it further in my worksheet? If so, how do I shorten it?

Thanks!