Forum Discussion

steveccc's avatar
steveccc
Brass Contributor
Nov 30, 2019
Solved

Delete Duplicate Rows With Text Arranged in Different Columns

Hello, I have built 500 NBA fantasy team lineups composed of 8 players each.   Some players can be designated in multiple positions (different columns), and this leads to duplicate teams.   For e...
  • CA_PUNIT_AGARWAL's avatar
    CA_PUNIT_AGARWAL
    Nov 30, 2019

     steveccc 

     

    I have tried to solve your query:

    Solution Steps:

     

    1. Firstly i have assigned numbers to each unique person name (in Sheet 1)

    2. I have used index and Match function to assign values (in sheet 1) to each cell

    3. I add up those values. Now since every person is assigned different values so if sum of values are equal in different rows than they are identical (Persons in rows with same or different positions)

     

    Please check it out

     

Resources