I have 2 columns of data. One is USERID and the other one is DATE JOINED.

However, in the USERID column, there are duplicate ID which i want to delete them. Currently, the best i could do now is to go to Data>Filter>Advanced Filter to filter out the duplicate and apply it to a new column.
But what i want is, after filtering out the duplicate, the other column's (DATE JOINED) data will also be filtered accordingly. I tried to group the 2 columns but to no avail. The same userid might have 2 different dates.

Thanks.