-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
formula autofill
-
D
Formula Autofill Debugging Help
Hello, I have a VERY strange error happening in one of my Macros that for the life of me I sure can't figure out. The weird thing is that this was working just fine before and now the error has crept in somehow. Basically I was using a very basic formula in H1 that just calls a value from F1...- dmelt253
- Thread
- debugging formula autofill
- Replies: 5
- Forum: Excel Questions
-
M
Help Needed: Pattern Formula.
Hey Everyone. i definitely need some help. I am making an excel sheet and I have put in a formula =SUMIFS('23.03.15'!BH$4:BH$135,'23.03.15'!$C$4:$C$135,$C10,'23.03.15'!BG$4:BG$135,$D10).. Now the thing is When I drag it horizontally BH$4:BH$135 changes to BI$4:BI$135. What I want it is that I...- mwfazal
- Thread
- excel formula as cell reference formula autofill
- Replies: 5
- Forum: Excel Questions
-
J
Need Help
Need some help I want to have Column A auto fill based on what zone is entered in A1. I am having some problems right now as my formula has become really long the way I been trying and does not work for all Zones. is there an array or another type of formula? <tbody> Thanks...- JBJones82
- Thread
- autofill columns formula =if() formula autofill
- Replies: 4
- Forum: Excel Questions
-
M
Autofilling
Hey guys, I have 3 columns. A and B contain data and they go to about row 40,000. Column C contains the formula A B correlation coefficient -5.86603E-05 -0.000100231 0.704674723 -1.05436E-05 -2.15795E-05 0.756371125 4.63519E-07 -1.60549E-05 0.802302214 -5.53306E-06...- MrSak87
- Thread
- autofill autofill reverse formula formula autofill
- Replies: 1
- Forum: Excel Questions
