Is there any easy way to make this forumula Repeat?

I want to do 0-100, 101-200 etc..
But if I try to just drag and copy the forumla It insists on going
A1:A50 and then A2:A51, A3:52 etc...


Maybe something like the following csv file would meet your need. Fill in
the formula in B2 and copy it down.

_________________________________________________
64,"=COUNTIF(A:A,""<101"")"
876,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
345,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
975,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
366,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
436,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
248,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
235,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
532,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
4546,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
222,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
5653,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
444,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
222,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
5544,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
222,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
554,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
975,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
433,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
643,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
532,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
33432,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
222,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
335,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
3221,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
453,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
222,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)"
322,
542,
712,
7532,
673,
742
532
2342