Results 1 to 7 of 7

Thread: Formula to count the number of times a number appears in a row within in a text cell

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Seeker Chi's Avatar
    Join Date
    Jun 2015
    Posts
    17
    Articles
    0
    Excel Version
    excel 2013

    Formula to count the number of times a number appears in a row within in a text cell

    Hi

    I've attached a sample data, on the 'Data' tab, which shows in each cell a person's name, in short form or code, and a number, in bold, which denotes a placing number for each pairing of names.

    Beside each pairing, highlighted in pink, shown on the 'Pairs' tab, I wanted a formula to show the total number of times that they came 1=1st, 2=2nd, 3=3rd only, ignoring the 0=no placings.

    Just so you know, each person's name for each placing is listed with their own unique code on the 'Codes' tab which I would like to be incorporated in the formula. The reason being is that the listed names on the attached sample data only shows a small list of names and the formula(s) will eventually be used in a data with a vast number of names being approximately over 300 names.

    So I guess using Countif formula would not be suitable for this vast data.

    I hope this all makes sense and let me know if you have any queries about the attached data.

    Kind regards
    Chi
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •