Answer Posted / Bhoopendar Singh
To check for duplicate entries in Excel, follow these steps:
1. Select the entire column of data.
2. Go to the 'Data' tab, and click on 'Remove Duplicates.'
3. A dialog box will appear asking which columns contain unique values (in most cases, select 'All').
4. Click OK.
5. Any duplicate entries will be removed.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
