I have differnet repeated nos. in column A, and unique nos in column B. by
using countif function by puting the formula in column C1 i.e
=countif(A1:A30,B1) i can count the nos of B1 . but when i copy the same
formula at down rows by dragging the mouse then then the value of column is
changing from A2 :A31 , again in next cell it is A3:A32. i need used this
A1:A30 as constant this should not be change when i copy the same formula to
the down cells

Example:
A B C
211 211 =countif(A1:A30,B1)
123 123
211 511
511 258
258 111
211
111
111
123