Hi,

Please change the formula to =countif(A$1:A$30,B1) and then copy down.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"smina" wrote in message
...
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