Hi Madiya,

Put following formula in cell B2 and then drag

=COUNTIF($A$2:A2,A2)


H S Shastri


++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++++



"Madiya" wrote:

I have 19 digit text values in column A from A2 to A501.
Col A Col B
8991151420000560945 1
8991151420000560721 1
8991151420000560770 1
8991151420000560770 2
8991151420000560861 1
8991151420000560929 1
8991151420000561125 1
and so on.

I need to count duplicate text for each cell to be desplayed in
adjecent cell (Col B).

Need help with the formula as countif is not working in this
situation.

Regards,
Madiya