If you select one column, it removes duplicates from within that column. If you selct two columns, AFAIK, it looks at colA and col B together...

What output do you want to see? Please post a sample sheet, with a mocked up solution.


Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.