Larbec
09-30-2015, 04:26 AM
Mod,
Can you please delete this thread, my own ignorance. I took the $ out from in front of the B duh
I have removed the $ from a formula but when I try to drag down all the cells in BL;2 the formula is BI:2 to BI:1001 the $ keeps reapplying itself. What could be the possible reasons for this? Here is an example
=COUNTIF(BI2:BI$1001,BI2)-COUNTIF(BI2:$BI$2,BI2)
=COUNTIF(BI3:BI$1001,BI3)-COUNTIF(BI$2:$BI3,BI3)
=COUNTIF(BI4:BI$1001,BI4)-COUNTIF(BI$2:$BI4,BI4)
This is in column BL:2
I wanted to remove the $ and drag the cells down and it will not allow that to happen. It reapplies it. I want the first BI to move with the 3rdin the group like this below
=(COUNTIF(F2:F$1001,AX2)
=(COUNTIF(F3:F$1001,AX3)
=(COUNTIF(F4:F$1001,AX4)
Thank you
14473
Can you please delete this thread, my own ignorance. I took the $ out from in front of the B duh
I have removed the $ from a formula but when I try to drag down all the cells in BL;2 the formula is BI:2 to BI:1001 the $ keeps reapplying itself. What could be the possible reasons for this? Here is an example
=COUNTIF(BI2:BI$1001,BI2)-COUNTIF(BI2:$BI$2,BI2)
=COUNTIF(BI3:BI$1001,BI3)-COUNTIF(BI$2:$BI3,BI3)
=COUNTIF(BI4:BI$1001,BI4)-COUNTIF(BI$2:$BI4,BI4)
This is in column BL:2
I wanted to remove the $ and drag the cells down and it will not allow that to happen. It reapplies it. I want the first BI to move with the 3rdin the group like this below
=(COUNTIF(F2:F$1001,AX2)
=(COUNTIF(F3:F$1001,AX3)
=(COUNTIF(F4:F$1001,AX4)
Thank you
14473