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


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


    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!

Participate now!

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