Follow the below steps to get distinct values from a column in excel sheet to a blank column.
1. Select Data-Filter-Advanced filter
2. Set your list range to the range containing data whose distinct to be retrieved
3. Check Copy to Another Location
4. Check Unique Records Only
5. Set Copy To range to an empty range on the same worksheet.
For more Tips & Tricks in Excel, Click Here.
No comments:
Post a Comment
Please give your feedback, questions and suggestions. I will surely answer you.