Requirement
Unique distinct values are all cell values but duplicate values are removed.
Example sheet - How to remove duplicate values
Column A contains names, some cells have duplicate values.
Step 1. Select column which have duplicate values
Step 2. Click REMOVE DUPLICATE button
Step 3. Click OK button
Step 4. Click OK button
Step 5. Get distinct value
No comments:
Post a Comment