Identify Duplicate And Assign Custom Data

  • Hello Ladies and Gentlemen,


    How can I identify duplicates in 16 rows and assign a number based on its position? Example Workbook attached. But here is a sample of the issue and desired result



    Current


    Points Team Score
    16 A 100
    15 B 100
    14 C 90



    Desired


    Points Team Score
    15.5 A 100
    15.5 B 100
    14 C 90



    A macro is needed as there are 20 groups of 16 data sets. Only the Points row needs modified. Thank you!

    Files

    • Sample.xlsx

      (10.14 kB, downloaded 23 times, last: )

    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]