--Copy paste the data from sheet2 to sheet1
--Assign headers to the data
--Select the data range including the header.
--From menu Data>Filter>Advanced Filter>Copy to another location
--In copy to I have selected J1 and check 'Unique records only'
--Click OK will give you the unique list
--If you have blank rows; the result set will have 1 blank row...
If this post helps click Yes
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
