• Hi,


    Need your help to resolve this.....


    Column A has number or a word for e.g cell A1 has 1000, A2 has again 1000 ,A3 has 2000 and so on...


    I need a formula in B column which will show me exactly how many times its appeared in A column, i dont need the sum count of a word or number .
    [TABLE="border: 0, cellpadding: 0, cellspacing: 0"]

    [tr]


    [TD="width: 64"]asdf[/TD]
    [TD="width: 64, align: right"]1[/TD]

    [/tr]


    [tr]


    [td]

    asdf

    [/td]


    [TD="align: right"]2[/TD]

    [/tr]


    [tr]


    [td]

    asdf

    [/td]


    [TD="align: right"]3[/TD]

    [/tr]


    [tr]


    [td]

    asdf

    [/td]


    [TD="align: right"]4[/TD]

    [/tr]


    [tr]


    [td]

    asdf

    [/td]


    [TD="align: right"]5[/TD]

    [/tr]


    [tr]


    [td]

    asasas

    [/td]


    [TD="align: right"]1[/TD]

    [/tr]


    [tr]


    [td]

    asasas

    [/td]


    [TD="align: right"]2[/TD]

    [/tr]


    [tr]


    [td]

    asasas

    [/td]


    [TD="align: right"]3[/TD]

    [/tr]


    [tr]


    [td]

    dev

    [/td]


    [TD="align: right"]1[/TD]

    [/tr]


    [tr]


    [td]

    1000

    [/td]


    [TD="align: right"]1[/TD]

    [/tr]


    [tr]


    [td]

    1000

    [/td]


    [TD="align: right"]
    2[/TD]

    [/tr]


    [/TABLE]

  • Try this in B1:


    =COUNTIF($A$1:A1,A1)


    Drag copy down.

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

  • You're welcome! :)

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!