Announcement

Collapse
No announcement yet.

Summary Count Of Re-occurring Strings

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Summary Count Of Re-occurring Strings



    I have one column with a list of strings. the same string could be repeated more than once (20 times maximum, recurrence is variable).
    i need to create a second column which could return how many times the same string recurs. the number must be on the same row of the regardins string.

    see attacched file for further clarifications.

    thanks for helping without reward
    Attached Files

  • #2
    Re: String Recurring

    Hi Sissi, Welcome to the forum. How much are you willing to pay for this job?

    Thanks,
    Ger
    Check out our new reputation system. Click on the Like button under the post!
    _______________________________________________

    There are 10 types of people in the world. Those that understand Binary and those that dont.

    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

    The BEST Lookup function of all time

    Dynamic Named Ranges are your bestest friend

    _______________________________________________

    Comment


    • #3
      Re: String Recurring

      Solution attached. Pay me whatever you think that was worth.
      Attached Files
      Check out our new reputation system. Click on the Like button under the post!
      _______________________________________________

      There are 10 types of people in the world. Those that understand Binary and those that dont.

      Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

      The BEST Lookup function of all time

      Dynamic Named Ranges are your bestest friend

      _______________________________________________

      Comment


      • #4
        Re: Summary Count Of Re-occurring Strings

        Ger, did sissi pay you anything?

        Comment


        • #5
          Re: Summary Count Of Re-occurring Strings

          Dave, not a sausage. No PM either. Ban Hammer here I think.
          Check out our new reputation system. Click on the Like button under the post!
          _______________________________________________

          There are 10 types of people in the world. Those that understand Binary and those that dont.

          Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

          The BEST Lookup function of all time

          Dynamic Named Ranges are your bestest friend

          _______________________________________________

          Comment


          • #6


            Re: Summary Count Of Re-occurring Strings

            What a lousy thing to do to someone who has helped. 1 ban coming up.

            Comment

            Working...
            X