![]() ![]() ![]() The Advanced Filter option in Excel helps you filter duplicate values and copy the unique values to a different location. Check the ‘Unique records only’ option box and then click OK.Īdvanced Filter Popup Box Using the Advanced Filter Option.Then, once you have selected a cell on the worksheet, click the “Expand” option (). You can temporarily click the “Collapse Dialog” option ( ) to hide the popup window.In the “Copy to” box, enter a cell reference where the resultant values must be copied.Click the “Copy to another location” option to copy the values. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |