assuming your data is in Column A. Select the data in the column(including your heading).
Activate the Advanced Filter.
Select "Copy to another location"
Your list range should be your selection.
Leave "Criteria Range" blank.
Put any single cell address in the "Copy to" box (must be on the same sheet).
Select "Unique Values Only"
Click OK.
1 nhận xét:
I know this if off topic but I'm looking into starting my own blog and was wondering what all is required to get set up? I'm assuming having a blog like yours would cost a
pretty penny? I'm not very internet smart so I'm not 100% sure.
Any tips or advice would be greatly appreciated. Thanks
my blog: laser cellulite treatment
Đăng nhận xét