ssalazarjr
Board Regular
- Joined
- Jun 1, 2009
- Messages
- 158
I have a spreadsheet of about 35,000 rows. I have a formula in the column just to the right of it.
=IF($E27<EOMONTH($E$27,-1)+1,"",IF(AND($C27="",$G27<>"",$H27=-1,$O27<>"TRADE IN PHONES"),"B"&MATCH($G27,$G28:$G$60000,0)+ROW($P27),"Q"&ROW($P26)))
It is taking for ever to Autofill down the column. When I double click the pull handle it takes hours for the formula to Autofill to the bottem of the spreadsheet. I've even tried doing it by just going down 10 cells and it took 25 sec.
Can anyone explain why autofill is taking so long and how to make it go faster?
=IF($E27<EOMONTH($E$27,-1)+1,"",IF(AND($C27="",$G27<>"",$H27=-1,$O27<>"TRADE IN PHONES"),"B"&MATCH($G27,$G28:$G$60000,0)+ROW($P27),"Q"&ROW($P26)))
It is taking for ever to Autofill down the column. When I double click the pull handle it takes hours for the formula to Autofill to the bottem of the spreadsheet. I've even tried doing it by just going down 10 cells and it took 25 sec.
Can anyone explain why autofill is taking so long and how to make it go faster?
