Announcement

Collapse
No announcement yet.

Identify Duplicate And Assign Custom Data

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

  • 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!





    Attached Files
    The Only Dumb Question Is A Question Not Asked.

  • #2


    1. Insert a column between A and B.
    2. In B5: =IF(D5=D6,AVERAGE(A5:A6),IF(D4=D5,AVERAGE(A4:A5),A5))
    3. Fill down.

    Comment

    Working...
    X