Forum Discussion
Counting untill it is False, and continue
here is the data And I want B to fill with the result, as you can see we have 3 4.00 in the first 3 cells so in the B3 we need a 3, and from A4 to A7 we need a 4 in B7. And A8 To A9 we have again the same 4.00. So we need a 2 at B9. Thank you. Please help me with this
OMG ITS WORKING I GET IT. I watched some tutorial, I hover my mouse to the edge, HOLD CTRL + LeftMouseButton, and copy on the next B Column, and it counts it perfectly. But now is the question, Can I automate this, as you can see there is a lot to copy CTRL + SHIFT +LEFTMOUSEBUTTON dind't work. THANKS MAN, Im waiting for a answer
That's couple of clicks job for entire range, nothing to automate. Left click on corner of the cell, move down, release the button. If you have relatively big range, dragging the cell move it to tasks bar area, it will go much faster
With Ctrl+D you may, staying on the cell, type in reference bar reference on entire range to select it, Enter, Ctrl+D. That's all
Can you do it for me, I failed with the drag drop thing man im sorry. A BIG Thanks for helping. Im very beginner to this job.
At least couple of ways
1)
Stay on the cell, left click the dot at right bottom corner, keeping left button of the mouse pressed drag down, release the button. Result is
2) Stay on the cell with formula and select all cells till end of the range (e.g. press Shift and sequentially PgDown)
Press Ctrl+D. Result is