- Go to Data > Filter > Advanced Filter
- Click 'Copy to Another Location' under 'Action'
- Check 'Unique Records Only'
- Enter the range of records in the list range and critera range
- In the Copy to box, type the address of or select the first cell where you want the information to be placed. Make sure there is enough room so you don't overwrite pre-existing data.
- Hit 'Ok'
Who is online
Users browsing this forum: No registered users and 1 guest