PDA

View Full Version : [SOLVED] Trying to drag cells down and $ keeps reapplying even after deleted



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

Aussiebear
09-30-2015, 08:05 PM
We only delete threads which either breech the forums rules or may be subject to some form of legal action. The one good positive note on this is that anyone else who visits the forum can learn from this by simply reading through the thread. If you still feel strongly about the issue, PM me and I take it up with the Administrators.

Larbec
09-30-2015, 08:51 PM
You can leave it. I am okay with that for others to learn from

Thanks