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.
Hello frend11, welcome to the forum.
I'm not quite sure I understand. With UserID in column A and DateJoined in column B, you can define columns A and B to be the filtered table, so any row that is filtered out will be filtered out in both columns. Or is that not what you want?
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks